[DB2-L] strange error in sortbld in load and reorg REASON=X'00E40322'

PUSCH Othmar

[DB2-L] strange error in sortbld in load and reorg REASON=X'00E40322'
Hi dear Hanne !
o) The utility-maintask (--> X'00E40322' ) tries to give info's from the failing subtask to DD-SYSPRINT --> are there not more info's in your failing JOB in JES2-DD_SYSPRINT ?
o) Ya should get an SVC-Dump in this situation (--> X'00E40322') ... if not --> the index is internally 'unavaible' --> IBM-Support from my point of view needed.
Only ideas; kinds & yours sincerley / Othmar :-)

________________________________

Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Hanne Lyssand
Gesendet: Freitag, 04. Jänner 2008 14:10
An: [login to unmask email]
Betreff: [DB2-L] strange error in sortbld in load and reorg REASON=X'00E40322'



We did a series of upgrades to the system.

We applied some ptf's to the z/os system 1.8

We upgraded the db2 earlycode to 9.1 (we are still in 8 NFM otherwise)

The dataset is SMS handled.



What we see is some more or less "random" error in both reorg and load utilities. It seems to be more than enough space on the volumes and it's few but some exents. It looks like the trouble occurs when we need a new extent. Sometimes just a rerun solves the problem without any changes.



Not much error messages on MSTR or DBM1 the only thing we get is this in the job:



DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=1506795

DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:01:56

-DB2I DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=1506795 FOR INDEX INFOGEN.XDV343

-DB2I DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=1506795 FOR INDEX INFOGEN.XDV342

DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40322' CAUSE=X'000E0000'

DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40347'



Any help will be appreciated



Best regards

Hanne






The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information < http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Hanne Lyssand

Re: strange error in sortbld in load and reorg REASON=X'00E40322'
(in response to PUSCH Othmar)
We have applied UK28175 that makes a change to *.SDSNLOAD - DSNUTILC
A bit early to confirm that this take care of the problem but we are optimistic.

Thanks for tips.
Best regards
Hanne

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms