APAR status
INTRAN
Error description
Following is a status list of V9 DB2 NATIVE SQLPL APAR/PTFs with PUT Service level *=Major and PTF *=Hiper. . . . APAR# V9 PTF# PUT 2007 Listing Lastest First ---------------------------------------------------------------- PK42013///v9-UK24925 0705 0C7 DSNXRDEC +3E92 SQLPL SPROC Deci PK43475///v9-UK29006 0705 PERF, NATIVE SQLPL unnec Tracing PK45372///v9-UK25814 0705 INCOR SQLCODE? VALIDATE(RUN) PK42197///v9-UK26599 0707 *INCOR ASSIGNING TIMESTAMP CHAR 20 PK44782///v9-UK25663 0706 0C4 RC3B DSNXRSPL+63DC DIAG=SP Native PK45322///v9-UK25826 0706 04E E70005 DSNXISB7:P126 ALTER PK47769///v9-UK27576 0708 0C4 RC38 DSNXOEXC+153 UDF Where/Havg PK48313///v9-UK27223 0708 04E E70005 DSNXOOS1 M110 GrpBy EXprsn PK48357///v9-UK27360 0708 04E E70005 DSNXEBPG M800 NativeSProc PK48566///v9-UK27228 0708 04E E70005 DSNXOYSR M003 SPROC Var PK48566///v9-UK27228 0708 04E E70005 DSNXOYSR M003 SPROC Var PK48675///v9-UK27660 0708 INCOR WRONG VALUE SQLPL COL >= SQL PK41153///v9-UK28579 0709 DUP SYSENV ROW SYSENVIRONMENT TABLE PK45265///v9-UK28544 0709*0C4 RC38 DSNXESPL +03A2 EDMPOOL FULL PK48544///v9-UK29131 0709 BIND SQLPL PROC PKG,PRIMARY AUTH used PK49049///v9-UK29078 0709 MISSING IFCID58 NATIVE SQLPL SPROC PK51319///v9-UK28998 0709 0C4 RC38 DSNONLLE+1222 INSERT XMLTAB PK49861///v9-UK29239 0710 0C4 RC38 DSNXEDBG +1CF0 DEV Workbench PK50942///v9-UK29449 0710 04E E70005 DSNXRLOB:P020 Null in LOB PK52384///v9-UK29684 0710 04E 0E70005 DSNXRLOB :P017 LOB PK42277///v9-UK30651 0711 04E C90101 DSNOLINS Insert Clob PK52967///v9-UK30191 0711*INCOR @ DELETE Qual Rows NATIVE SPROC PK53081///v9-UK30746 0711 04E E70005 DSNXGDT2 M204 UDF PARMS+ PK43035///v9-UK31502 0712 Missed SQLWARNING SQLPL to SQLPL PK47577///V9-UK31590 0712 NF UK31590 Package path -4706 ALTER PK55268///v9-UK31879 0712 04E E70005 DSNXEFDA M500 INCOR SECTn PK55817///v9-UK31778 0712 Incor 04E E70005 DSNXECNT:M170 EXECu PK56431///v9-UK31710 0712 04E-E70005 DSNXGRDS.DSN :P000 Zero/ . APAR# V7 PTF# V8 PTF# PUT 2008 Listing Lastest First ---------------------------------------------------------------- PK54893///v9-UK32412 0801 04E E70005 DSNXRRP M110 betw+ PRED PK55548///v9-UK32978 0801 04E RC00E70005 DSNXGDT2:M112 Insert PK56197///v9-UK32943 0801 INCOR Create | ALTER w/QUAL ATTRIBute PK57420///v9-UK32742 0801 04E C90101 DSNGEPLC:5002 REBIND PK58789///v9-UK32910 0801 0C4 RC04 DSNHSMF3 +3AE0 BAD SYNTAX PK58174///v9-UK33180 0802 04E E70005 DSNXGDT2 M111 UDF PRED PK55829///v9-UK33851 0803 04E E70005 DSNXGDT2:M100 RANK in SEL PK56585///v9-UK31487 0803 04E E70005 DSNXI14 P038 ALTER PK57518///v9-UK33846 0803 0C4 RC04 DSNXRECP +09B2 Static EXCEPT PK57796///v9-UK33863 0803 INCOR SQLC-904 LOBVALA EA. SQLPL CALL PK61561///v9-UK35059 0804 04E E70005 DSNXEBPG:M801 Bind Cat Acc PK62520///v9-UK35757 0805*04E E70005 DSNXRFF M105 ALTER Warning PK62866///v9-UK35675 0805 0C4 RC04 DSNXGRTM+2622 ALTER UDF Refg PK44664///v9- CANC 0C7 RC0 DSNXRDEC +A848 PAR SpecREG . PK64894///v9-UK36839 0806 04E 0E70005 DSNXODTR P310 Ascii LIT PK62575///v9-UK36961 0806 INCOR SQLC905 MISCALC RLF ASUTIME TOT . PK62575//v9-UK36961 0806 INCOR SQLC905 MISCALC RLF ASUTIME TOT PK66442//v9-UK38539 0808 INCOR SLC-567 BINDADD CURRENT SQLID PK70519//v9-UK39802 *0809 INCOR SQLC-423 FETCH SET LOB VARIABLE PK69457//v9-UK39430 0809 INCOR DSNXRDI MISSING RDISTYPE VALUES PK72834//v9 UK40530 0810 04E E70005 DSNXEBPG M800 INCOR ISNULL PK71080//v9-UK41290 0811 04E E70005 DSNXOBFC:M999 PAR SQLPL PK71470//v9-UK41817 0812 INCOR SQLEXCEPTION HANDLER SQLPL SPROC PK72798//v9-UK41870 0812 04E E20004 DSNXGXTB.DSNSVBK +05E0 ARRY PK74006//v9-UK42106 0812 0C4 RC38 DSNXOTF +23BC BIND Explain PK74778//v9-UK42199 *0812*INCOR Pkgs W/PAGE_RANGE='Y' PLAN_TABLE . APAR# V9PTF# V9 PUT 2009 Listing FIRST to LAST --------------------------------------------------------------- PK70593//v9-UK43338 0902 NESTED SQLPL SROC DO NOT COMMIT CHGS PK76383//v9-UK43300 0902 INTEGRITY SQLC552 ALTER DROP VERS PK63677//v9-UK45848 0905 PERF SUBOPTIMAL UTIL DB2 STORAGE w IF PK80508//v9-UK46338 0905 SQLC501 "CLOSE CURSOR" CALL in SPROC PK81948//v9-UK46676 0906 0C4 RC3B RC10 DSNXEPP+29B2 SQLC992 REMOTE BIND SQLPL DEPLOY Cmds PK76839//v9-UK46818 0906 INCOR DEFECTS 11270, 112030 & 116375 PK88664//v9-UK47880 0907 MSG DSNH199I SQLC199 FETCH-1st FULLSEL PK87355//v9-UK48508 0908 0C4 RC38 DSNXGMVE 01C2 REMT BND DEPLOY PK88890//v9-UK49940 0909 INCOR SQLC-430/SQLC-901/-20203 W/JAVA . PK85962//v9-UK50511 09nn INCOR SQLC-270 FUNC W/A FOR & DO ON VW PM00174 OPEN INCOR with select PK65583///v9-UK37823 0807*0C4 RC11 DSNXRSBC 5822 & OTHER ABENDS PK65611///v9-UK40290 0810 SQLCODE,SQLSTATE NOT RESET AFTER CONTINUE HANDLER PK65648///v9-UK40265 0810 INCORROUT WHEN A WARNING OR EXCEPTION OCCURS PK72251///v9-UK50519 0910*MULTIPLE INCORROUT AND ABEND FIXES PK97411///v9-UK51461 0911 SQLCODE4476 FROM JDBC DRIVER TYPE 4 PK98322///v9-UK51929 0911 INCORROUT BETWEEN PREDICATE WITH REOPT ALWAYS PK91936///v9-UK52077 0912 LOOP ON CREATE WHEN MANY VARIABLES PK97225///v9-UK52074 0912 04E RC00E70005 DSNXRLOB P014 WITH LOB . -APAR -v9- DATE Description for 2010 ----------------- . PK96804///v9-UK53945 1002 LOOP ON BIND COPY WHEN NO SQL STMTS PM03212///v9-UK53946 1002 INVALIDLY ISSUED SQLCODE206 PM03399///v9-UK53980 1002 0C4 RC38 DSNXOYTR 3188 E206 PK96874///v9-UK52943 1003 04E RC00E70005 DSNXRRP M110 PM00684///v9-UK53729 1003 SQLCODE592 SQLCODE552 NOT ISSUED FOR UNAUTH BIND DEPLOY PM06676///v9-UK54944 1003 0C4 RC38 RC38 DSNXEDBG+051E Set CURR PM06770///v9-UK52943 1003 04E RC00E70005 DSNXESX2 P404 OR DSNXESX4 P404 PM12154///v90UK56504 1005 04E C90101 DSNILGCL:5008 & DSNL031I PM06440///v9-UK57052 1006 04E RC00E70005 DSNXRFF M900 PM15059///v9-UK58394 1007 04E E30001 DSNTBAS2+1F86 REMOTE BIND PM18114///v9-UK60396 1009*INCOR SQLC-407 LOB VARIABLE NULL NOT . -APAR -v9- DATE Description for 2011 ----------------- PM13844///v9-UK63420 1101 NF PRECOMPILER SUPPORT SQLPL MIGRAT PM23401///v9-UK64486 1102 04E E70005 DSNXRRP:M100 INSERT PM31776///v10-UK66622 1104 DUP IFCID401 RECORDS,Section 1 PM31770///v9-UK66390 1104 INCOR SQLC-313 CONNECT STATEMENT PM34933///v9- FIN Loop|04E E20033 DSNXRSPL+0069BF Strg PM35275///v9- FIN SQL-206 SQLVAR WITHOUT AS NAME|REBIND PM32517///v9-UK67262 1105 INCOR(MORE ROWS) FETCH FIRST N ROWS PM31624//UK69747-746 11nn INCOR SQLC-904 E30083 00000801 DROP PM37425//UK69717-716 11nn DROP PROCEDURE, NEVER ENDING THREADS PM38119//UK69434-433 11nn 04E E70005 DSNXRSPL:M517 UNRECOGNIZ- PM37668//v10-UK69705 11nn NF STORED PROCEDURE RETURN TO CLIENT PM38571//UK69464-463 11nn 0C4 RC04 DSNXECWA+01CC CANCEL LARGE SP . PM40502///v9- OPEN INCOR PREPARATION REXX CODE PM29226 PM43676///v9- OPEN INCOR SQLC 100 NATIVE SQL PROCEDURE PM43758///v9- OPEN PERF HI CPU/STRG,SQL CONDITION PM43934///v9- OPEN 04E E70005 DSNXESX2+P404 miss RELOCAT> . . . . . SQLPL 5740XYR00
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
II14400
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
2008-05-21
Closed date
Last modified date
2011-07-19
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:
19 July 2011