APAR status
Closed as canceled.
Error description
INACTIVE THREAD support ( CMTSTAT = INACTIVE in ZPARM ) fixes: search keywords: DB2INACTIVE (" DDF THREADS CMTSTAT INACTIVE ") 5740XYR00 In DB2 dump LCOMINAC=on (LCOM+'72'x = 1... ....) ================================================================ APAR/PTF V6: PQ27123 UQ33969 PUT9908 DDF SUSPEND/RESUME SUPPORT TO ALLOW DDL. PQ27165 UQ32326 PUT9907 HANGING DDF THREADS AFTER SECURITY VIOLA PQ28955 UQ32814 PUT9908 COMMON STORAGE CREEP OF RBLK (RBLOK) PQ29940 UQ34596 PUT9909 MESSAGE DSNL032I DSNLCRTD 00D3101A DSNLCRTD0022 FOLLOWED BY ABEND04E DSNLVDDC:0002 PQ29978 UQ34410 PUT9908 04E 00D31200 DSNLQDIS+01C0 PQ32920 UQ37904 PUT9912 ERROR IN NEW FUNCTION MODE=SUSPEND, DB2 PRIVATE PROTOCOL NOT ALWAYS BLOCKED. PQ33880 UQ39177 PUT0001 WITH USING INACTIVE THREAD SUPPORT, A HELD CURSOR WHEN AN APPLICATION TERMINATES PQ35288 UQ40449 PUT0002 ABEND0C4 IN DSNLQACT +X'1244' PQ35416 UQ40368 PUT0002 SQLCODE601 ON DCL GLOBAL TEMPORARY TABLE (PQ32670 NEW FUNCTION) W/DB2 CONNECT PQ35770 UQ40936 PUT0002 ABND=04E-00E30001 DSNTACT +042A PQ36620 UQ43863 PUT0005 INCORRECT VALUE IN QDSTQDBT PQ36808 UQ42844 PUT0004 INCORROUT IN DISPLAY THREAD OUTPUT FOR INACTIVE THREAD DSNV437I PQ38457 UQ44155 PUT0006 INTERMITTENT SQLCODE817 W/ DDF INACTIVE PQ38723 UQ43987 PUT0006 ABEND878 RC10 SP230 KEY7 2K DIST STORAGE PQ38535 UQ45495 PUT0007 ABEND04E RC00D3440B IN DSNLXPRS:0001 THIS PROBLEM ONLY OCCURS IN DB2/390 V6. PQ38647 UQ43880 PUT0006 ABEND0C4 AT DSNWDSDM +B4 / CANCEL THREAD PQ39191 UQ44856 PUT0007 ABEND0C4 IN DSNLCSRM BASE LEVEL +X'1146' PQ39954 UQ45402 PUT0007 INTERMITTANT SQLCODE817 CMTSTAT=INACTIVE PQ41083 UQ46769 PUT0009 SQLCODE571 ISSUED INVALIDLY W/ INACTIVE PQ42290 UQ48057 PUT0010 ABEND0C4 IN DSNLQACT+0EA0 PQ43169 UQ50524 PUT0102 SQLCODE551 W/ INACTIVE THRD & RACF EXIT PQ43746 UQ49362 PUT0012 CANCEL DDF THREAD WITH INVALID TOKEN PQ44000 UQ49391 PUT0012 ABND0C4 PIC4 DSNLCDG2+03E2 PQ44002 UQ49471 PUT0101 ABEND0C4 PIC11 DSNLCLCN +3B2/ SQLCODE571 ABEND04E RC00D31010 DSNLCSRM :000D PQ44185 UQ49641 PDO0101 ABEND04E RC00D30014 DSNLATRN :0002 PK14140 Retrofits V7 APAR PQ93454. =============================================================== APAR/PTF V6 and V7: PQ45889 UQ51702/UQ51703 PDO0109 SQLCODE440 PQ46325 UQ51837/UQ51838 PUT0103 ABEND0C4 DSNLSSST or DSNLEDDA PQ48562 UQ54125/UQ54126 PUT0106 BLANK CONNECTION NAME IN DISPLAY PQ49241 UQ55125/UQ55126 PUT0106 Missing IFCID 3 accounting recor PQ48864 UQ55130/UQ55131 PUT0106 0C4 DSNXERT+FA4 PQ49924 UQ55556/UQ55557 PUT0107 Release deallc used for release PQ49480 UQ56372/UQ56373 PUT0108 not terminate after deallc abend PQ51264 UQ57412/UQ57413 PUT0109 multi abends PQ51782 UQ61225/UQ61229 PUT0201 sqlcode725 PQ47167 UQ53453/UQ53454 PUT0105 CURSOR HOLD NOT FREEING LOCK AFT (UQ53452 db2 v5) PQ48709 UQ55584/UQ55585 PUT0107 LOB RELATED LOCKS NOT RELEASED PQ53905 UQ59747/UQ59748 This APAR applies because without (UQ59746 db2 v5)the fix, a hung DDF service task could result which may prevent Disconnected DBATs from terminating per POOLINAC DB2 configuration value. VTAM OW51457 is needed too. PQ52810 UQ59635/UQ59636 PUT0111 DSNL030I 00D31034 incorrectly de PQ55401 /UQ61291 PUT0112 0C4 DSNLTDDF (DB2 V7 ONLY HIPER) PQ55760 UQ61281/UQ61282 PUT0112 0E0 00000034 DSNLDTI2+04B6 PQ56509 UQ62145/UQ62146 PUT0202 DPSB storage leak PQ57289 UQ62909/UQ62910 PUT0203 Storage overlay & unpredictable (UQ62908 v5) HIPER PQ55496 UQ62913/UQ62914 PUT0203 0C4 DSNIZMOV+000340 PQ52648 /UQ60698 PUT0112 Threads not going inactive in V7 PQ58652 UQ65700/UQ65701 PUT0205 Unexpected IFCID 3 accounting re PQ61762 UQ67588/UQ67589 PUT0207 ABEND04E RC00D31200 DSNLQDIS +01 PQ61806 UQ67586/UQ67587 PUT0207 Detect damaged TLISAHSH chain. PQ63185 UQ69523/UQ69524 PUT0209 Release Deallocate packages PQ65231 UQ69433/UQ69434 PUT0209 Display Thread Type Inactive inc PQ55192 UQ61662/UQ61163 PUT0112 ABEND0C4 DSNLDALB+138C DSNLITRM+ PQ58887 UQ65006/UQ65007 PUT0204 ABEND0C4 PIC4 DSNLBABR +DD0 PQ57183 UQ64219/UQ64220 PUT0204 DSNVSTK RC00E20016 FOLLOWED BY (UQ64218 v5) HIPER RC00E50702 PQ58166 UQ66137/UQ66138 PUT0206 RC00E50702 AFTER DDF THREAD (UQ66136 v5) CANCELed PQ59120 UQ67918/UQ67919 PUT0207 No acctg record from old user to new user after db2 connect drda connection. PQ63444 UQ69320/UQ69321 PUT0209 ABEND0C4 DSNLVINF +0794 PQ63589 UQ69257/UQ69258 PUT0209 ABEND04E RC00E20005 DSNSVBK +8F8 STORAGE ABEND INVOKER IS DSNLZS00 PQ65147 UQ69511/UQ69512 PUT0209 ABEND04E RC00D30014 DSNLTCLI:001 PQ59567 CLOSED MSGDSNT501I RC00C9008E TYPE00000100 for Temp table PQ67619 CLOSED Display Thread Inactive report error PQ67723 CLOSED 0C4 DSNILABR, SQLCODE -906 PQ72182 CLOSED 0C4 DSNLVFVS PQ72053 CLOSED 04E 00E20005 DSNSVBK+08F8 PQ72883 CLOSED 04E 00D31200 DSNLQDIS+01DE PQ73900 CLOSED PQ76321 ECSA consumed w/ "DDXB Storage Pool" PQ76515 04E 00E30001 DSNTACT+042A followed by DB2 termination 00E50705. PQ78337 0C4 DSNLQINA+0A4C PQ78896 04E 00E50001 PQ79412 04E 00D31010 DSNLCAIA:0005 PQ79717 DDF RBLK POOL STORAGE GROWTH IN SP231 PQ84142 Incorrout output PQ90949 PE FIX FOR PQ84142 V8 FIX UQ89626 ONLY PQ93454 INACTIVE ACCUMULATING w/Socket CLOSWT PQ84335 04E-00E20005 DSNSVBK PQ85299 0C4-00000010 DSNVDTA+183C PQ86456 0C4-00000004 DSNLCSRM+1082 PQ87861 RLF PQ91695 QDSTHWAT incorrect PQ87861 UQ88848 Various errors w/ADRLFMAX in Acctg repor PQ94468 PQ99021 PTF for V7 and V8: PK01336 UK01033 UK01034 HIPER PUT0503 abend04e rc00e20003 PK02259 UK01825 UK01826 HIPER PUT0502 abend0c4 pic11 dsnvsr +444 PK03084 UK02070 UK02071 HIPER PUT0504 abend04e dsnlmtok :0001 PK04403 UK02952 UK02953 HIPER PUT0505 abend04e dsnlmtok :0001 PQ99771 UK03286 UK03287 PUT0505 Client Hang / Maxdbat=0 online c PK03908 UK04733 UK04734 OPEN IFCID3 acctg record / rc00d3003b PK04871 UK03306 UK03307 HIPER PUT0505 abend0c4 pic11 dsnlcncl PK00311 UK02306 UK02307 PUT0504 abend04e rc00e20005 dsnsvbk PK05629 UK04398 PUT0506 abend04e rc00e20005 dsnsvbk PK07195 UK04838 OPEN sqlcode440 -440 PK08606 PK11646 CLOSED PK11878 CLOSED ACEE (CCBACEE) leak PK12892 CLOSED 04E-00E50097 PK12507 CLOSED 04F-00E50702 PK12560 CLOSED NEW TYPE 2 INACTIVE CONNECTION HANG WHILE STOP DDF QUIESCE PK19008 CLOSED 0C4-4 DSNLQACT and potential 04E-00D30014 DSNLDALB secondary abend resulting in DB2 crash. PK19974 UK12181 CLOSED V8 0C4-00000004 DSNLTINT PK20672 UK12489/UK12490 CLOSED V7 INCORROUT when VALIDPROC references RVALPLAN field. PK21621 UK13146/UK13147 CLOSED 0C4-00000011 DSNLAGNT+13C8 PK21787 UK13123/UK13124 CLOSED 04E-00E70005 DSNXI14 PK21961 CLOSED 0C4-00000011 DSNLDTI2 DSNVDTAD PK23823 CLOSED Invalid 00D3003B condition PK23955 UK14560/UK14561 CLOSED SQLCODE -440 incorrect CURRENT PATH special register PK26119 CLOSED SQLOCODE -440 incorrectly sent back for CURRENT PATH special register. PK26270 CLOSED 04E-00D30014 DSNLSSST PK08128 CLOSED 0C4-00000011 DSNLDTI2 PK30098 CLOSED 0C4-00000004 DSNLDTI2 PK29824 CLOSED 0C4-00000011 DSNSFBK+073A PK36125 CLOSED 0C4-00000010 DSNSFBK PK36971 CLOSED 04E-00E20005 DSNSVBK PK32436 CLOSED Sequences PREVAL incorrect PK36862 CLOSED WLM ArrivalTime corrections PK41636 CLOSED QDSTQDBT incorrect PK41833 CLOSED Stored Procedure debugger PK35706 CLOSED Various abends and incorrout PK44035 CLOSED SSTL SRGV storage leak PK41646 CLOSED Inbound name translation PK47136 CLOSED DSNL030I 00D31034 PK48306 CLOSED -911 DSNT376I with DISCONN PK46171 CLOSED WPKT leak if CVTSUP=False PK55392 CLOSED QDSTQDBT incorrect PK53583 CLOSED Incorrect plan name PK55868 CLOSED Stop DDF Suspend AB0F8-10 PK52743 CLOSED 04E-00D35111 DSNLZRDT:029A PK55838 CLOSED 00D3003B after PK32436 PK54176 CLOSED PK51331 CLOSED PK58734 CLOSED 0C4-11 DSNLQCTL+0AB6 PK68492 CLOSED Invalid -843 on Set Connection PK76470 OPEN Invalid plan ID PK62808 OPEN QLACMDWT description changes. PK86507 OPEN 04E-00D31100 instead of -842. PK85641 UK47193/UK47194 CLOSED SQLCODE -204 due to wrong CURRENT SCHEMA value returned by DB2 PK94387 OPEN ABEND0C4-00000004 DSNLCDG2+0CFA or DSNLZS01+1F60 PK94943 OPEN 04E-00E20005 PM08659 QDSTPOOL value too high PM12154 04E-00C90101 DSNILGCL:5008 PM15838 Stop DDF Mode Force hang PM16077 SQLCODE -30020
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
Closing Informational APAR.
APAR Information
APAR number
II12675
Reported component name
PB LIB INFO ITE
Reported component ID
INFOPBLIB
Reported release
001
Status
CLOSED CAN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2000-12-26
Closed date
2001-02-23
Last modified date
2010-06-22
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"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"001"}]
Document Information
Modified date:
14 December 2020