A fix is available
APAR status
Closed as program error.
Error description
An UNLOAD of a LOB tablespace with SPANNED YES got into a loop and never ends. The Unload dataset is on tape but the problem also happens using vtape. At the time of the dump the job is still positioned on first tape volume but appears not to write anything. Console dump analysis showed the loop being in DSNUULMB between offsets +ABA and +CF6 (level UK94806). It looks an internal variable went negative when blksize is greater than 32767 .
Local fix
Manually specify a BLKSIZE less than 32K for the unload dataset (or disable LBI Large Block Interface for datasets) .
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS * * users of the UNLOAD utility with SPANNED * * YES and SYSREC on TAPE utilizing Large * * Block Interface (LBI). * **************************************************************** * PROBLEM DESCRIPTION: Endless loop during an UNLOAD utility * * with SPANNED YES and the unload * * (SYSREC) data set is on TAPE and * * using Large Block Interface (LBI). * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available * **************************************************************** An UNLOAD SPANNED YES utility of a LOB table space went into an endless loop and had to be cancelled. The unload SYSREC data set was on TAPE and TAPEBLKSZLIM=65535 was set in SYS1.PARMLIB to utilize LBI. UNLOAD SPANNED YES does not support the Large Block Interface and will now ignore a block size that is greater than 32 KB.
Problem conclusion
UNLOAD SPANNED YES utility code has been modified to ignore the Large Block Interface for the SYSREC data set on TAPE. The data set will utilize system determined blocksize (SDB) and the records will continue to be written in the variable blocked spanned format. The Utility Guide and Reference manual has been updated to document that UNLOAD SPANNED YES ignores the Large Block Interface. It will be added to the following sections: Data sets that online utilities use UNLOAD utility under the SPANNED keyword UNLOAD utility under Unloading data in spanned record format
Temporary fix
Comments
APAR Information
APAR number
PI26452
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-09-25
Closed date
2014-12-22
Last modified date
2015-02-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI24205 UI24206
Modules/Macros
DSNUGSDA DSNUULDB
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
06 May 2020