APAR status
INTRAN
Error description
Following is a cont'd list of DB2 V8/V9 LOB fixes (involving Lobs, Blobs, Clobs, LongVarchar). Customers utilizing LOBs are encouraged to be current with this service, apars that affect LOB follow standard support procedures and critical data corruption/integrity should be marked HIPER. *All LOB HIPER apars should be applied; '*' = Hiper. . Please note any references that list ' * MAJOR FIX ', please go to at least that level fix, plus any HIPERs. . OPEN indicates we are working on that APAR. 04nn indicates we are waiting on PTF closure/availability, the the APAR is Closed and the PTF is orderable. . RSU - Recommended Service Levels links for DB2 + . http://www-03.ibm.com/servers/eserver/zseries/zos/servicetst/get serv.html . http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp ?topic=/com.ibm.db2.doc.inst/dmigadj2.html . Here is a link you can find Version 8 FixPaks and clients http://www-1.ibm.com/support/docview.wss?rs=71&uid=swg21256235 . APAR# V7/V8/v9 PTF# PUT 2007 List Latest First --------------------------------------------------------------- PK34761/UK21113/UK21114 0701 04E D31010 DSNLIRTR 001E SQLC-518 PK36317/n.a. /UK21462 0702 INCOR SQLC450 SPROC LOB PARM V8 Mig PK36621/n.a. /UK21909 0702 0F8 RC10 UNLOAD of a LOB PK35381/UK21443/UK21446 0702*04E C90101 DSNOTCSO 5004 CREATE LOC PK35493/n.a./UK21512 0702*INCOR SQLC0/SQLTYPE IN SQLDA -804 PK36253/UK22067/UK22068 0702*C90101 DSNOLADS :500C rollbk lobs PK35525/UK21641/UK21642 0703 CCSID E40350 C90072 DBCS Mixed Data PK36065/n.a./UK23026 0703*INCOR DEC CONV LOAD DELIMITED W-IGN PK19145/n.a./UK23696-96 0704 IMPROVE SPACE REUSE FOR LOB DATA PK36234/n.a./UK23069 0704 04E E20016 DSNSVSTK 05E8 DBCLOB PK43940/UK25161/UK25162-63 0705 UPDATE LOB COL W-TRIGGER,ROWID JR25411 UDB APAR fixpk C90101 on DB2 LUW INSERTS LOB DATA PK29750/UK25088/UK25089-90 0706 INCOR ORGRATIO LOB TABLESPACES PK43731/n.a./UK25588 0706 04E C90101 DSNOGETD:5064 INSERT PK45434/n.a./UK26011-12 0706 SQLC30081 COMM ERR at LUW CLIENT PK45807/UK26031/UK26032 0706 E20004 DSNSVBK 0610 UNLOAD PDSE PK45864/v9-UK25797 0706*INCOR 2Many LOB COL, w-UR JCC Driver PK46076/n.a./UK25876-884 0706 DSNU1407I COPYTOCOPY b4 ImageCopy PK46079/v9-UK26257 0706 NewZPARM PRGSTRIN Default Prg Streaming PK46727/v9-UK26146 0706 D34450 DSNLXXSS006E USING JCC . PK44585/v9-UK26440 0707 0C4 DSNICLAP+0E18 WRONG LOG REC FORMAT PK44966/v9-UK26289 0707 0C4 DSNOPGNX+0C5A or 04E DSNOLFRV:501E PK45657/v9-UK26340 0707 DSNU1508I RECOVER LOB TBS w-Not Logged PK46063/v9-UK27036 0707 04E E20016 DSNSVSTK+0634 Merge w/Updt PK46441/n.a.//UK26319 0707 Incor SQLC330 or -330 EBCDIC Table PK46518/n.a./UK26419-20 0707 REMOVE DSNTIAUL DEPENDENCY LONG COL PK47044/UK26515/UK26516 0707*C90101 DSNONLLE :5063 data sharing PK45787/n.a./UK27551 0708 PERF Improve Extend Lobs PK46464/v9-UK27173 0708 04E E70005 DSNOGLOB:5001 INSERT PK47415/v9-UK27248 0708 0C9 RC09 DSN1COPY INDEX SPACE PK47536/v9-UK27409 0708 0C4 RC3B DSNOCLEN+0250 w-DIST PK47606/v9-UK27266 0708 XML UNLOAD HFS Files INCOR PERMISSIONS PK45702/v9-UK26446 0709 LISTDEF W-EXCLUDE CLAUSE & XML Keyword PK46478/v9-UK28974 0709*04E C90101 DSNINUKY:5002 CHECK DATA PK48032/v9-UK28730 0709 DSNU076I Lists BASE TBS AS LOB TBS PK51319/n.a./UK28997-98 0709 0C4 RC38 DSNONLLE+1222 INSERT XMLT . PK46965/n.a/UK29758 0710 Incor Value B4 Trigger Sqlc-803 PK47245/v9-UK29634 0710 DSNU1176I vs DSNU068I LOAD INLINE CPY PK47326/UK29360/UK29361-62 0710 0C4 RC4 DSNOLROG+1DF0 REORG TBS PK50272/n.a./UK30171-72 0710 ALTER MAXROWS DSNDB06.SYSSEQ PK51570/UK29369-70-71 0710 DSNU518I DSNUBASA 0C09 CPY CHKPG PK52675/n.a./UK29811 0710 UNLOAD INVALID KEYWORD "CLOBFMIXED" PK53040/UK30057-58-59 0710 04E-E40350 DSNURWBG+88DE Load,frv PK51889/n.a./UK30654-55 0711 DSNTESP SDSNSAMP Queries MISMATCH PK51550/n.a./UK31738-39 0712 REPAIR RC:00; but LOB Broken arch PK52419/n.a./UK32186-87 0712 04E E72018 DSNXSTSE+17B6 C9000B PK53033/UK31460-61-62 0712 C90101 DSNKINSL ERQUAL5005ISMATCH PK53286/n.a./UK31898 0712 04E E40350 LOB UNLOAD, no rc: PK54393/n.a./UK32152 0712 04E-C90101 DSNOTCSO:5005 POSITION . APAR# V8PTF# V9PTF# PUT 2008 Listing FIRST to LAST --------------------------------------------------------------- PK57796///v9-UK33863 0803 SQLC-904 LOBVALA EA SQLPL CALL Insert PK60541//v9-UK34533 0803 SQLC-904 D50001 XMLAGG,XMLELEMENTTMT PK60624//UK34052-53 0803*SQLC171/-171 DSNXRLOB INCOR BLOB Lech PK60044//UK34947-48 0804 Expl Stmt Cache Ifcid 318 report PK60636//v9-UK35494 0804 0C4 DSNIRNXT+3ECE TABLE hidden rowid PK61112//UK34714 0804 0C4 RC04 DSNLXRBF+0FB6 V8 REQ/V9 SERV PK60636//v9-UK35494 0804 0C4 DSNIRNXT+3ECE TABLE/hidden rowid PK61882/UK35150-151 0804 LOAD UTIL C900D1 TYPE 907 TBS w/FRV PK63096//v9-UK35342 0804 INCOR B4 Updt Trigger Updt Lob Col PK63414/UK35468 0804 C90101 DSNOTCSO 5004 Scalar Func LOCATD PK63188/UK36440-440 0805 04E C90101 DSNODAL1 5003 Delete AuxIDX PK63398//v9-UK35979 0805 PERF LobMgr Storage Leak Fetch Continue PK63461/UK36236 0805 04E E40350 DSNURWBX+A2FE LOAD File HFS PK64252/UK36484-485 0805 0F8 DSNLIRSY DSNL033I D31010 DSNLIRTR PK64323/UK35864-865 0805 INCOR DSNH501I Precompiler H:V Rowid PK64327/UK36442-443 0805 UNLOAD Lob 2 PDS Dir Blocks Limit . PK61693//UK36699-700 0806 DSNP007I DSNPXTN0 D70011 EXTEND FAILED PK62294//v9-UK36622 0806 INCOR DDL Create Mbr Cluster SimpleTBS PK62834/UK37034-035 0806 04E C90101 DSNOLMDE 5002 Mass Delete PK64300//v9-UK37337 0806 04E C90101 DSNGDVRT 5004 After Trigger PK64376//UK37141-142 0806 INCOR RUNSTATS >100 ORGRATIO in SYSIBM.SYSLOBSTATS RGRATIO in PK64480/UK36994-995 0806 PERF Incremtnal IMAGE Copy of Lob TBS . PK63442/UK37573-583-584 0807 C90101 DSNIFPSC &Others FRV Syntax PK63781//UK37495-496 0807 04E C90101 DSNONLLE 5063 ZPARM SPRMNLG PK64454//v9- CLSD 0C4 PIC11 DSNIATPR +1688 After UPDT Trig PK67062//UK37733 0807 D70100 C90096 NUMLKUS CROSSLOADER LOB PK67927//v9-UK38014 0807 INCOR XML2CLOB OrderBy,Truncated Field PK61841//UK38390-391 0808 ENHANCE V9 ID INCOMPLETE OBJECT Def PK62027//v9-UK38906 0808 NF Lob Locking Enhancement w/o Grp-Out PK67968//UK38776 0808 INCOR Corrupt Lob Data SYSJAUXB v8 CAT PK69505//UK38790-791 0808 OCI MSGDSNU745I DSNI747I CHECK IDX LOB PK64648//UK38542 0809 0F8 RC10 DURING LOB UNLOAD PK69021//v9-UK39243 0809 INCOR DSN held SQLC-452 UNLOAD LOB FRV PK67830//UK39285-286 0809 04E D31010 DSNLCCNR 0014 COLDescriptor PK70519//v9-UK39802 0809 Incor SQLC423 Lob Locator Cursor Select PK67558//v9-UK40613-614 0810*SQLC445 INSERT INTO LOB COL SQLPL PK69255//UK40466-467 0810 Incor TBS PageSize Calc LOBFRV PK70065//UK40357-358 0810 Incor PAGEs IMAGE COPY (COPY FULL NO) PK70097//v9-UK40014 0810 DSNTIAUL LOBFILE CAN'T UNLOAD LOB PK70942//UK40490 0810 LOADING LOB VARCHAR CLOBF E40350' X'63' PK65220//v9-UK41212 0811 NF DK1053:EXTEND APPEND KEYWORD Lob TBS PK70958//v9-UK42466 0812 INCOR GRANTOR=GRANTEE SYSIBM.SYSTABAUTH PK70958//v9-UK42466 0812 INCOR GRANTOR=GRANTEE SYSIBM.SYSTABAUTH . APAR# V7PTF# V8PTF# V9 PUT 2009 Listing FIRST to LAST ---------------------------------------------------------------- PK70565//v9-UK42792 0901*UNLOAD 04E C90101 DSNOTCSO:5005 Lob Col PK76549//v9-UK42907 0901 04E D31010 DSNLCCNR:0014 Lobs or XML PK75216//v9-UK43355 0902 PERF LOAD FILE REF VARIABLES OPEN/CLOSE PK75776//cancelled CARDF INCOR EMPTY LOB COL, UNLOAD/LOAD PK77000//UK43894,UK43895 0902 C90101 DSNIBMCL:5001 C20040 Parts PK77116//UK43415 0902 C90101 DSNILREP:5037 imcomplete LobTBS PK80104//UK44762 0903*CORRUPT DATA UNLOAD BLOBF LOB DSN PK80165//UK46242,UK46243 0903 SQLC904 C90096 F01 CROSSLOADER PK81481//UK45726,UK45727 0904 04E D31108 DSNLCCLO:000E SQLC803 . PK82815//UK46084 0905*INCOR LOB SPEC LED TO DB2 OUTAGE PK82975//UK46138 0905 04E E40350 UNLOAD 0LEN LOBS PARTS TBS PK84235//UK46446,UK46447 0905 INCOR LMSEQ Order LOB MAP PAGES PK85214//v9-UK46653 0905 04E C90101 DSNOLMAT:5006 UNLOAD LOB FRV PK85276//UK46596,UK46597 0905 MSG DSNH104I CHAR|BIN Lrg Obj SQLT PK83992//UK46269,UK46270 0905 UNLOAD LOBS/XMLS W/O FILE REF VARI PK85097// FIN MSGDSNH644I, ERR IN SPEC LOB DATATYPE LEN . PK84804//v9-UK46670 0906 CROSSLOADER 32K PAGESISE LOB TBS, 0Len PK85704//v9-UK46795 0906 INCOR ASXBUSER DBM1 ASID OVERLAYED dLck PK85797//UK47338,UK47339 0906 04E C90101 DSNOFRLC:1001 SharedLck PK86351//v9-UK46980 0906 D351FF ('PARSER: DATA MISMATCH') INSERT PK86646//UK47176,UK47177 0906 04E 0C9 RC09 DSNOLSCN +26C2 CHKIDX PK87276//v9-UK47228 0906 INCOR CREATE IDX AUX TBL W/PIECESIZE PK83096//UK47615,UK47616 0907 PERF COPY LOB SHRLEVEL D/Sharing . PK84995//UK47477,UK47479 0907 04E C90101 DSNOPUFF:5001 STARJoin PK85890//UK47584,UK47585 0907*04E C90101 DSNOLDEL:5005 +EXTENT PK86403//v8-UK47717 0907 DB2 Outage Load LOB Strg belowline PK87434//v9-UK48308 0907 04E C200B0 DSNB1REL+0318 CLOSESTMT PK83096//UK47615,UK47616 0907 PERF COPY LOB SHRLEVEL D/Sharing PK87942//UK48063,UK48064 0907 SQLCODE432 DSNXRIHS SQLERRD1-470 PK88175//v9-UK47649 0907 04E DSNGDVFI:500C Create TBS . PK80588//UK49933,UK49934 09O9 04E-00D35111 DSNLZHC2:004 HOP PK87552//UK49482,UK49483 0909 PERF INSERT LOB TBS EXTENDING NEW PK91051//v9-UK50925 0910 INCOR CODEPAGE CONVERSION,FILE NME PK92089//v9-UK50940 0910 04E C90101 DSNOLDEL:500 PK92430//v9-UK51715 0911 04E C90101 DSNIOST2:53B6 UPDT PK96531//UK51885,UK51886 0911 0C4 DSNISRTI DSNILREP LOB|Triggers PK96391//UK52813 0912 SQLC-305 DSNTIAUL LOBFILE PARM PK96623//UK51204,UK51205 0911*0C4 RC11|10 DSNSVBK UNLOAD DELIMIT PK96655//v9-UK51735 0911 SQLC-904 DSNOTCSO C900D2 INSERT PK97687//UK51627,UK51628 0911 04E E30001 DSNTLCAU+07FC +0850 ACE PK98270//UK51708,UK51709 0911*C90101 DSNODAL1:5003 SPACEMAP PGs PK96391//UK52813 0912 SQLC-305 DSNTIAUL LOBFILE PARM PK97225//v9-UK52074 0912 04E E70005 DSNXRLOB P014 SQLPL . -APAR# V8PTF#-V9 PUT -- 2010 Listing By DATE --------- PK92338/UK52970,UK52971 1001 0C4 RC11 DSNUBALS(UK45995)+06DC PK97446// ,UK53032 1001 SQLC-904 DSNOTCSO C900D1 INSERT PK99245// ,UK53462 1001 INCOR REORG LOB NOT Releasing TAPE PK99730// ,UK53630 1002 INCOR SQLC100 FETCH CURRENT CONT PM07095/UK54738-UK54739 1003 04E-D34425 DSNLXRBF:000D remote XML . PM04836/UK55711,UK55712 1004 NF 04E C900D8 DSNOFRLC:5009 FETCH PM09277/ ,UK55762 1004 SQLC-310 DSNXRIHS MRI Lob Data H PM04711// pe v9-UK55768 1005*INCOR UNLOAD XML UNICODE COL -20412 PM08466// ,UK56677 1005 04E 0E70005 DSNXRUFS:M121 LOB HV PM10796/UK57885,UK57886 1006 04E C90101 DSNGDVIX:5018 CreateDrop PM14381/UK58747,UK58748 1007 SQLC904 MSGDSNT501I DSNOTCSO C900D1 PM10342// v9-UK60704 1010 04E DSNOGETD:5064 LOB FRV DIST PM20496// v9-UK60716 1010 MSGDSNT501I C900D1 TYPE 907, INSERT PM19845/UK62021,UK62022 1011 MSG DSNU1508I Recover Using TORBA PM21636/UK61575,UK61676 1011 0C4 DSNXORLI+08DA LOB PARSortGrp PM21872/UK62036,UK62037 1011 04E C90101 DSNILREP+5046 PBG TBS PM22836//v8-UK62041 1011 0C4 RC11 DSNIOPNP+0956 REORG Scope PM22671// v9-UK61895 1011 INCOR datatype new logic DSNAHVPM PM23779// v9-UK61410 1011 04E D31010 DSNLIGLM+0014 XML QRYDTA PM19845/UK62021,UK62022 1011 INCOR MSG DSNU1508I RECOVER TORBA PM21733/UK62798,UK62774 1012 04E E70005 DSNXVTRS+1C0 LOADING LOB PM23975/UK62324/UK62324 1012 04E E4D5D2 DSNUKDRN+5534 CHK IDX . -APAR# V8PTF#-V9-VA PUT 2011 Listing By DATE --------------- PM10233// FI N NQF NF RESTRICT USAGE RELATIVE PATH USS PM21676/UK63114,UK63139 1101 INCOR UNICODE Load INCURSOR (CROSS PM24721//v10-UK63457 1101 BIND PERF IMPROVEMENT LOB TBS PM29831/UK65989-990-988 1103 MISC Z/OS INSTALLATION FIXES PM30911/UK65809-810-808 1103 DBD LOCK ACQUIRED DYNAM STMT CACHE PM31500//v9-UK65896-985 1103 04E C90101 DSNOLFRV:500F file Ref PM32170//v10-UK65503 1103 CHECK DATA LOB TBS UNDEFINED COL PM33285//v10-UK65648 1103 CHECK LOB CLEARS CHECFKLAG SETTING PM30751//v10-UK66305 1104 SQLC-20016 ALTER TABLE ADD LOB COL PM31820//v8-UK66785 1104 0C9 RC09 DSNOGETD+2580 PM32444//v8-UK67029 1105 04E E20003 DSNSVBK+061A LISTDEF PM34519//v8-UK67276 1105 SQLC904 DSNXRLOB ERRD1-665 C90001 PM36056//V10-UK68903 1107 04E C90101 DSNIRSET+53B6 Pred Eval PM36529//UK68703-702 1107 INCOR WRONG VAL INSERT XML TABLE PM37439//UK69611-610 1107 SQLC105 INSERT BLOB TYPE COL ASCII PM39573//UK69209-208 1107 04E C90101 DSNOLADS:500B DB2 REStart PM39933//UK68958-957 1107 SQLC670 DSNXOWIN -110 Select w/V10 PM39064//V10-UK68981 1107 SQLC904 C9000A TAB INSERT PBG TBS PM40696//V10-UK69330 1107 DSNU180I UTIL NOT COMPATIBLE CHK LOB PM41669//UK69774-773 1107 INCOR 2FEW PLAN_TABLE SQL STMT SQLPL PM39997//UK69952-951 1108 CALL REXX STORED PROC W/LOB PARM TE PM38035/UK70104-105-103 1108 04E C90101 DSNGDVRT:5005 Cast2 CTE PM39997//UK69952-951 *1108 Incor Call REXX SProc Lob parm PM38776//UK70759-758 1108 04E C90D01 DSNOTCSO+519C +5630 UPDT PM41436//v9-UK70135 1108 CONCAT CLOB SQLC904 C900D1 CCSID PM39444/UK71923-924-922 1109 04E-E72018 DSNXSTSE+0A9C OrderBy PM43689//UK71488-487 1109 MSG UNLOAD LOB wFILE NAME CONTAIN $ PM42865//V10-UK71877 1110 0C4 DSNIETRV+54DE REORG PARTN TBS . -APAR# V8PTF#-V9-VA PUT 2012 Listing By DATE --------------- PM43441//UK74045-044 12nn LISTDEF Not EXCLUDING LOB TBS PM43186//v8-v9 12nn INCOR GBPCACHE LOB TBS in CHANGED PM34459//v9- OPEN SELECT WITH UR GETS DSNONLLE:5063 . . . . Search criteria Keywords: LOB HIPER ------------------------------------
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
II14334
Reported component name
PB LIB INFO ITE
Reported component ID
INFOPBLIB
Reported release
001
Status
INTRAN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-10-15
Closed date
Last modified date
2012-01-13
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
13 January 2012