IBM Support

II12836: DB2 V8/V9/V10 QUERY PARALLELISM RECOMMENDED MAINTENANCE INFORMATION LAST UPDATED JAN 13, 2012

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • INTRAN

Error description

  • This Informational APAR is being replaced by FIX CATEGORY
    (FIXCAT) for IBM.DB2.Parallelism, Keyword DB2PARALL/K .
    See more information about FIXCAT at
    http://www-03.ibm.com/systems/z/os/zos/smpe/fixcategory.html
    .
    Following is a list of DB2 V7-V8/V8/V9/V10 Query parallelism
    PTFs customers utilizing query parallelism are encouraged to
    be current with these RSE Service fixes.
    APAR # V6 PTF#   PUT
    _______ _______  ____  _________________________________________
    .............  RML level (ESO 0003)   ..........................
    .
    Earlier Fixes were removed from the list to make room for more
    <current> available releases.
    
    .
     APAR#  V7 PTF# V8 PTF#   PUT      2006  Listing Lastest First
    ---------------------------------------------------------------
    PK35403/n.a./UK20491  0612XCo-Existent D/Sharing DB2 Mbrs Unqual
    PK34803/n.a./UK20532  0612 04E E72100 DSNXSPKY+04DA NLJgrp SortC
    PK32841/UK19791/UK19792 612 0C4 RC10 DSNXRSTP+5E36 IFCID221 PGrp
    PK33671/n.a./UK20138  0612 04E C90101 DSNISPBM:5001 +31D0 DPSI+o
    PK30804/n.a./UK20143  0612 0C4 RC10 DSNXPREC+0CD8 > DSNXRCGP
    PK30548/n.a./UK19937  0612 INCOR Calc Workld Sharing DSNTTTC+
    PK33224/n.a./UK19356  0611 04E E70005 IN DSNXRLPT P160 NLJ PGrp
    PK31752/n.a./UK19032  0611* INCOR NRF Null mismatch OJPERFEH=no
    PK31843/n.a./UK18523  0610 04E E70005 DSNXEET M400/strg boundary
    II14219 DB2 Z/OS ZIIP EXPLOITATION "SUPPORT USE" INFORMATION.
    PK30940/UK18605/UK18606 0610*INCOR NO COL DATA PAR SORT GROUP
    PK30537/n.a./UK18607  0610 DSNTTSPD Hang DSNXECLN & DSNRUA01 FRE
    PK28329/UK17321/UK17322 0609*INCOR NRF OR MULTI-ROWS In(List Asc
    PK27869/n.a./UK17527  0609*04E E20005 DSNSVBK+0A36 DSNXEFB stats
    PK27097/UK17692/UK17693 0609 0C4 RC04 DSNIWNRF+022A Empty WKFL
    PK26612/UK17443/UK17444 0609 0C4-3B DSNXPDAL+02DC MultiPAR
    PK28433/UK17261/UK17262 0608 04E E70005 DSNXESX2:P403 PAR Join
    PK27009/UK16541/UK16542 0608 0C4 RC11 DSNXRSJ+157C IFCID 58 SJ
    PK26744/ n.a. /UK16998  0608 04E E72100 DSNXSPKY+04DA Key Ranges
    PK26192/ n.a. /UK17034  0608 0C4 DSNB1ULT+B1REL D94001 PCB
    PK24033/UK16172/UK16173 0607 0C4 RC4 DSNX9CAC 2412 USING PAR
    PK24032/ n.a. /UK16237  0607 04E DSNXXGEN:M678,DSNXOGRL:M105 XML
    PK23833/UK14588-589   0606 0C4 RC11 DSNXRECD+1316 LOJ CPU
    PK23610/UK15131-132   0606 04E D35111 DSNLZSR3:005F SQLCA
    PK19244/UK14684-685  x0606 HANG DSNTTSPD(UQ63333)+0350 50013
    PK21958/N.A./UK13633  0605 04E E70005 DSNXOLDE:M040 SubQry Null
    PK21955/N.A./UK13834  0605 04E E70005 DSNXGDT2:M201 Case Clause
    PK20779/N.A./UK13690 x0605 04E E72100 DSKXSPKY+026E SortKeyLengt
    PK22043/                   AE PK13004 Fix completion
    PK13004/UK11771-790  X0604 HANG DSNTTSPD Timg WrkFl Remote
    PK15115/N.A./UK11929  0603 HUNG DSNTTSPD CANCEL EU Switch
    PK18502/UK12354-355   0603 04E E30001 DSNTTENE+028C & 0C6 RC06
    PK17101/UK11119-120   0602 0C4 RC04 DSNXRIPE+2DDA C9003F
    PK15908/N.A./UK10672  0601YINCOR NRF, PAR Group Sort/InList
    PK15505/UK10605-606   0601 0C4 RC38 DSNXOFPD+0EF2 StarJoin
    PK14563/N.A./UK10207  0601*04E E70005 DSNXEET:M400
    .
     APAR#  V7 PTF# V8 PTF#   PUT      2007  Listing Lastest First
    ---------------------------------------------------------------
    PK31359/n.a./UK19794  0701 04E C90101 DSNISJNF:5007 PUSH DOWN SJ
    PK31410/n.a./UK19337  0701 04E E70005 DSNXEFDA:M500 Invalid PIPE
    PK35443/UK21201/UK21202 0701*04E E70005 DSNXOLCS M090 Like varch
    PK32857/UK20788/UK20789 0702*Strg Overlay Select stmt, Key Range
    PK33989/n.a./UK20790  0702*INCOR Value Count(Distinct) MJTables
    PK30487/n.a./UK21763  0702 INCOR After alter Rotate Partition
    PK36405/n.a./UK22233  0703 04E E70005 DSNXEFDA:M500 <DSNXPCRT
    PK37755/n.a./UK23349  0704 INCOR Rows PartKeys Len<SortKey Len
    PK27693/n.a./UK23967  0704 0C4 RC04 DSNXPSNP +18BE INVALID LATCH
    PK42035///v9-UK23817  0704 0C4 RC11 DSNISRID,C90101 Ridmap
    PK41396/UK24044/UK24092 0705 SQLC-404 Sel Order By Varchar Cols
    PK41747/UK24546/UK24547 0705 INCOR Value Qry w-Count TABLE SCAN
    PK42119/UK24181/UK24182 0705 04E C20305 DSNB1RWI +02D2 Exists
    PK41955/n.a./UK25039    0705 POOR PERF ON AN INSERT WITH PAR
    PK42453//UK25575/UK25576 0706 INCOR PREDICATE VARCHAR C1=''empty
    PK43216//UK26430/UK26431 0707 04E E70005 DSNXGTSK/DSNXGSOR M257
    PK44734//n.a./v9-UK27104 0707 0C4 RC3B DSNXOCU+03DC DSNXOCU+041A
    PK44955/UK27874/UK27875-76 0708*INCOR 2Few HYBRID JOIN overflow
    PK45344/UK27416/UK27417-18 0708 0C4 RC3B DSNXPDAL+02C0 serialize
    PK46464//n.a./v9-UK27173  0708 04E E70005 DSNOGLOB:5001 INSERT
    PK47137//UK28205/UK28206  0708 04E C90101 DSNIRIDR:5003 MultiIDX
    PK47184/UK27544/UK27545-46 0708*INCOR Insert Select w/Expression
    PK47246/UK27986/UK27987-88 0708*RIDPOOL/Exceed Proc.Lim.wPK39680
    PK47513//UK28313/UK28314  0708 0C4 RC10 DSNIOST2_3D16 bad MSIPRC
    PK48056/UK28207           0708 0C7 DSNXVCDF+0264 Col=Subqry Pred
    PK49282/UK28367/UK28368   0709 0C4 DSNXSORI+3DE4 Pre V3 SPL
    PK50136//UK28358/UK28359  0709 04E C2025A DSNB1MPP+0216 MBA Lock
    PK46972///V9-UK28211      0709 HANG Deadlock with DPSI Querytion
    PK50918//UK28938/UK28939  0709 0C4 RC3B DSNXPRE3+0304 QCapture
    PK51309///v9-UK29041      0709 0C4 RC10 DSNXSORI+3C00 Sort clnup
    PK49566//UK29276/UK29278  0710 Perf Low2/Hi2Key PAR Ranges IDX
    PK51356///-v9 UK29335     0710 0C4 RC04 DSNXOGRL+2B76
    PK49358//UK29764/UK29765  0710 Hung Cancel Thread DSNTTSPD+0DB8
    PK51018/UK29532-33-34    0710*0C4 RC38 DSNXRSTP+60C6 IFCID221 1
    PK51117//v9-UK29514      0710 0C4 DSNIWKFT Workfile cub
    PK52530/UK29776/UK29777 x0710 04E C90101 DSNICMTC:1009 Multi-WF
    PK52133//UK31311/UK31312 0711 0C4 RC38 DSNXOFPD +122C Corr SJ
    PK53218//UK31059        X0711 0C4 RC11 DSNXPRE2+0DA0 TTSPD +0DB8
    PK53793/UK31118-19-20    0711 0C4 RC38 DSNXOJW +1928 INSERT
    PK51707//UK31581-UK31582 0712 INCOR DSN3AUCN Traces IFCID83 SOPR
    PK54848//UK31479         0712 0C4 RC04 DSNXOLCS+1730 INSERT (SEL
    PK54851//UK32012/UK32013 0712 0C4 RC38 DSNXOLCM+B918 Tab NPI
    PK54848//UK31479         0712 0C4 RC04 DSNXOLCS+1730 INSERT (SEL
    PK55938/UK32317-18-19    0712 04E E72200 DSNXSPRM+130 ridmapMult
    .
     APAR#  V7PTF# V8PTF# V9 PUT      2008  LISTING FIRST to LAST
    ---------------------------------------------------------------
    PK55236//UK32636/UK32637 0801 04E E70005 DSNXESX2:P403 BndPkgSrt
    PK55717//UK32828/UK32829 0801*INCOR 2Many PAR Group In Predicate
    PK57066///-v9,UK32891    0801*INCOR 2Few Sel DGTT SEGSIZE=0 WKF
    PK56911//UK33272/UK33273 0802 04E E70005 DSNXOLCS:M30
    PK57683//UK33538/UK33539 0802 04E C90101 E30100 DSNIBCTD:5007
    PK59067///-v9,UK33181    0802*INCOR Result Col Value Lost  PAR
    PK58768//UK33540/UK33541 0802*INCOR NRF SnowFlake Par Grp I/O
    PK60603//UK34229/UK34230 0803 0C7 DSNXRDEC+2B92 View In(List
    PK61186///-v9,UK34320  0803 04E E50079 DSNVSRX +1732 PW Join
    PK61791//UK35497,UK35498 0804 0C4 DSNXOLCS +2014 MatchPRED=0
    PK61816//UK35512       0804 Perf/Enable PAR Partitioned IDX+Cols
    PK62064///-v9,UK35539 0804*04E E20002 DSNSVBK +08B0 *Major FIX
    PK59077///-v9,UK35741 0805 04E E70005 DSNXEFDA:M500 WKFL RC
    PK61678///-v9,UK36191 0805 04E E20006 DSNXECLN DSNSVBK 093A Curs
    PK61680///-V9,UK35956 0805 DSNTTSPD HANG, DSNXECLN & DSNRUA01
    PK62650//UK35678,UK35679 0805 0C4 RC04 DSNXRSOR +0180 NotIN(Sel
    PK62758//UK35668,UK35669 0805*INCOR SEL W-GROUP BY Outer Join
    PK63643///-v9,UK35909 0805 0C4 RC38 DSNXGPGR+0E1E Nested IN(SQ
    PK63651///-v9,UK35670 0805 0C4 RC38,RC10 DSNXRTSC +0A8C PWJoin
    PK57429///-v9,UK36966 0806 PERF CPU PAR Initiating Stored Proc
    PK61388///-v9,UK36891 0806 04E E70005 DSNXEBR:M216 RDA Extens
    PK62882///-v9,UK37025 0806 04E E70005 DSNXGPGR:M160 INNER HYJn
    PK53221///-v9,UK37110 0806 04E E70005 DSNXESX2:P404 RANK
    PK62815///-v9,UK37604 0807 04E E70005 DSNXOFPD:P006 SEL DIST+
    PK65062//UK37383-384 0807 04E E70005 DSNXORLI:P001 UNION/UNIONA
    PK65210///-v9,UK38158 0807 04E C90101 DSNIONXP XML Corr(SQry
    PK65583///-v9,UK37823*0807 SQLPL 0C4 DSNXRSBC+5822 *Major FIX
    PK65803//UK37581,UK37582 0807 04E DSNXEFDA:M500 NLJ SORTC Order
    PK66441//UK38159-160 0807 04E E72100 DSNXSPKY+0502 null/PartWF
    PK63491//UK38343-344 0808 CROSS LOADER SET CURRENT SQLID=ANY
    PK69437//UK39026-027 0809 04E C90101 DSNIBCTD:5007 nestedIn(Sel
    PK65844//UK39404    X0809 PAR TASK HANG on Zero Rows
    PK66947//UK39278-279 0809*Incor Sel Count(*) NRF Null Pred/IDX
    PK69297//-v9,UK39497 0809 AE BINDX PARALLELISM SUPPORT SPATIAL
    PK70161//UK39282-283 0809 04E C90101 DSNIZMOS:500B INSERT (Sel
    PK66181//-v9,UK39955 0810 ADDITIONAL DB2 R9 SPATIAL SUPPORT
    PK67238//v9,UK39849  0810*Incor 2Many Subqry Table has SortC
    PK67288//UK39891-892 0810*Incor NRF with Non-PAR UDF PredicateL
    PK70154//UK39843-844 0810*INCOR 2Few PAR SelLIST Union Leg LIT
    PK72342//UK39843-844 0810*AE PK70154 0C4 RC04 DSNXORLI+0D70
    PK70461//UK40808-809 0810*INCOR Garbage UDF ALLOW PARALLEL  L
    PK72262//UK40406-407 0810 04E E70005 DSNXOJW:M040 Self-Ref INS
    PK69468//-v9,UK41330 0811 AE RUNX PARALLELISM SUPPORT SPATIAL
    PK71493//-v9,UK41459 0811*0C4 RC11 DSNXPSEN +07F5 INVALID PIPE
    PK72413//-v9,UK41522 0811 0CF RC0F DSNXOLDE +6AD2 HISTOGRAM
    PK72881//UK41651    X0812 04E E70005 DSNXRTSC:M090 Outer Join
    .
     APAR#   V8PTF# V9       PUT      2009  Listing FIRST LAST
    ---------------------------------------------------------------
    PK72830//-v9,UK42813     0901*INCOR GROUP BY & OC4 DSNXOLCM
    PK75080//UK43080,UK43081 0901 B1REL+07D0,+0318 B1RTR+1268 SQry
    PK75308//UK43396,UK43397 0902 04E C90101 DSNIGWAC CPU StopDB
    PK76030//UK43129,UK43130 0902 INCOR SQLC802 SetFunction GBy
    PK74383//UK44257,UK44258 0903 04E E70005 DSNXEFDA M500 Pipe Err
    PK78787//UK44821,UK44822 0903 04E E70005 DSNXEFDA M500 DSNXPRE3
    PK79379//-v9,UK44259     0903 0C4 DSNXRSTP+36F4 PKG BOUND IN V7
    PK79415//-v9,UK44980     0903 04E C90101 DSNIWKFT:5003 PAIR-WISE
    PK80139//-v9,UK44927     0903 0C7 DSNXRRP +6C7C SUBQUERY = ANY
    PK74980//-v9,UK45352     0904 PERF w/PAR, DISABLE DEGREE=1
    PK82271//UK45374         0904 04E E70005 DSNXOLCM:M050 XML Qry
    PK79858//UK45566,UK45567 0904 04E E30001 DSNTTTGE +092C ORPHAN
    PK80803//-v9,UK45835     0905*04E E70005 DSNXRLPT:P340 E20027
    PK81663//UK46017         0905*INCOR TOO FEW PGroup Multi-SMJ
    PK64223//-v9,UK46088     0905 NF/SERVICEABILITY PAR Task CLEANUP
    PK79680//-v9,UK46458     0905 04E C9021A DSNISFWL 5008 WORKFILES
    PK82169//UK46342,UK46343 0905* INCOR VALUE SEQUENCE OBJECT
    PK82555//-v9,UK46255     0905 04E C90101 DSNIWNRF:5008 IN SUBQRY
    PK85107//-v9,UK46645   0905*INCOR 2FEW TABLE JOIN IDX PAR ACCESS
    PK84133//UK47199         0906 04E E50097 DSNB5COM +553C bad ROB
    PK81852//-v9,UK47375     0906 INCOR +ROWS FETCH FIRST N ROWSROB
    PK85677//-v9,UK47352     0906 0C4 RC38 DSNXOLL+0CA2 pairwise SJ
    PK86347//-v9,UK47394     0906 04E E70005 DSNXRPJP:M117 pairwise
    PK86537//UK47392,UK47393 0906*0C7 DSNXVCDF+02E4 INSERT(SEL SFunc
    PK85550//UK47595,UK47596 0907*INCOR 2MANY ROWS PAR SORT SET FUNC
    PK86168//UK48505,UK48506 0908*INCOR 2FEW OUTER JOIN & SUBQRY PAR
    PK86638//UK49101,UK49102 0908 04E E70005 DSNXORLI:M999 REPEAT
    PK86639//UK49107,UK49108 0909 04E E70005 DSNXORLI:P003 OUTERJOIN
    PK90477//UK49389,UK49390 0909 04E C200A2 DSNIWKFD+0F5A OuterJoin
    PK90935//UK49580,UK49581 0909*04E E20016 DSNSVSTK+05B8 Part IDX
    PK91405//-v9,UK49749     0909 04E E70005 DSNXRSTP:M260 IFCID 221
    PK91609//UK49963,UK49964 0909*INCOR FEW ROWS PG RANGES NON-PART
    PK92184//UK49965,UK49966 0909*INCOR+Rows FOJ PART KEYS|SORT KEYS
    PK92533//v9-UK49320   0909*INCOR FETCH FIRST N ROWS & OrderBy
    PK90370//v9-UK50619   0910 PERF ACCESS PATH OPT FOR N ROWS
    PK91409//UK50259,UK50260 0910 04E C200A2 DSNIWKFD+0F5A IN Subqry
    PK91688//v9-UK50467   0910 0C4 DSNXOLET+17FE Bound prior to V8
    PK84127//v9-UK48884   0911 MSGDSNT501I C90305 MAXTEMPS LIMIT qry
    PK92801//v8-UK50372   0910*0C4 RC38 DSNXOLCM+3F1C +others w/MQT
    PK92163//v9-UK50740   0911*04E C20103 C20042 C90084 WKFL TBS
    PK94466//v9-UK51168   0911 SQLINCOR FETCH FIRST N ROWS Select
    PK90629//v9-UK51636   0911XOPEN 0C4 RC04 DSNXPRE3+0BD8
    PK96530//UK51744,UK51744 0911*Incor 2Few Constants Inlists RUNX
    PK97013//UK52318,UK52319 0912*Incor Union Leg,Select LitConstant
    PK97313//UK53085,UK53086 0912 0C4-04 DSNXEET +0738 +073C D/Shar
    PK98279//   ,UK52162 1209 RC6C Type D02 DSNDB007 DSNIWKFL SMJ
    .
    -APAR    -v8 -v9-    DATE Description for 2010 --------------
    PK96980//   ,UK53319 1001 0C4 RC04 DSNXOGP+2134,DSNXOOP:M888,
    PK88936/UK53834-835  1002 0C4 RC11/RC04 DSNTTRUN+01F0,+1870  70
    PM05030//   ,UK54360 1003 PERF Seq Cost INNER TABLE NLJFL SMJ
    PM06770//   ,UK52943 1003 04E E70005 DSNXESX2 P404 SQLPL DGTT
    PM04569/UK55819-820  1004 04E E70005 DSNXORLI:P010 Nest OuterJ
    PM05644/UK55846-847  1004 0C4 RC04 DSNXRSTP+7D5E IFCID 221  rJ
    PM05879/UK55764-765  1004 Hung,04E DSNTLDU+06A4,DSNTTRUN+3C3A
    PM05871//   ,UK56135 1004 MAXTEMPS HIT TOO EARLY 00C90305
    PM06992/UK56122-123  1005 LEAK, DSNXPCRT+0D93 E50013 Remote Task
    PM07577/UK56377      1005 04E E70005 DSNXECT M600 QUERY PAR
    PM08383/UK56300-301  1005 0C4 RC10 DSNTTTGE+3424 DSNTTTGE+3608
    PM07850/UK56790-791  1005 0C7 DSNXRTIM+5400 timestamp
    PM08884/UK56701-702  1005 0C4 DSNXRTSC+0AEE, +0B42 RIDMAP Trans
    PM05717/UK56880-881  1006 I/O PAR INCOR SUBQUERY PREDICATE
    PM06735/UK57228-229  1006 DISABLING QRY PARVIA RLF DOESN'T WORK
    PM10333/   ,UK57569  1006 Perf/Loop Inner|Outer Join
    PM15153/             1007 0C4-38 DSNXEET+1CCE CLEANUP v5 Task
    PM06953/v9-UK58871 1007 INCOR SINGLE ENCLAVE CP PAR
    PM12054/v9-UK59692 1008 Perf Remove List-Prefetch Lead Table
    PM12863/UK58907,UK58908 1008 04E E72018 DSNXSINE+1334 Null VCHAR
    PM16020/UK59309-UK59310 1008 NF ADJUST PARALLELISM REDUCTION
    PM19456/v9-UK60115 1009 04E C90101 DSNIRNXT:501D SPRMSLDB
    PM18971/UK60113,UK60114X1009 04E E70005 DSNXOLDP:M060 pg-range
    PM11509/v9-UK60190 1011 Perf Suspension w/Pair Wise Join
    PM15331/v9-UK61589 1011*04E C200B0 DSNB1REL+0318 C9010E abendsds
    PM17138/v9-UK62023 1011* SQLC-20143 DSNXRSBC ENCRYPT PASSWORD
    PM17990/v9-UK61810 1011 INCOR NRF SIDEWAY REF PREDICATE UnionAll
    PM18566/v9-UK62313 1011 0C1|0C4|0C6 DSNIST2O prior v9 Task
    PM20429/UK61442-UK61443 1011*INCOR 2Few SMJ Partition Table
    PM20811/UK61539-UK61540 1011*INCOR SEL COUNT(*)from Tblename
    PM20917/UK61870-UK61871 1011*INCOR FULL OJ NULL PADDING XTable
    PM21636/UK61575-UK61576 1011 0C4 DSNXORLI+08DA LOB PAR SORTGRP
    PM22867/v9-UK62154 1011*04E E20027 DSNXOAF+0A02 1byte overlay
    PM08604/UK62505-06-04 1012*INCOR Less Rows SMJ SortN INLIST IDX
    PM22232/v9-UK62237 1012*INCOR SEL LIST SIDEWAY Ref XTable
    PM22749/UK62757,UK62758 1012 0C4 RC11 DSNXRFF+73F4|74C6 INLIST
    PM22796/UK62461,UK62462 1012 04E E70005 DSN P000|DSNXPRE2 02CA
    PM20207/UK62364,UK62365 1012 INCOR CP COUNT WITH IBM ZIIP Engine
    PM23606/UK62498,UK62499 1012 0CF-0F DSNXOLET+198E COLCARD=1 col
    PM22413/UK62268,UK62269 1012 04E RC11 DSNXRTSK+0968 CTRLEB 0
    PM24507/v9-UK63323 1012 04E C200A2 DSNBBM DSNB1GET+4858 I/OPAR
    .
    APAR / v8-v9-vA    Date Description for 2011
    ----------------------------------------------------------------
    PM22132/UK63411-412-410 1101 04E E20004 DSNXEAB+0446 2ColsGrp
    PM23709/v9-UK63848     1101*INCOR NRF NATIVE SQLPL PROC PAR DGTT
    PM25906/UK63873-874-872 1101 04E C90101 DSNIPSFI:5007 & INCOR
    PM26571/v9-UK63857-856  1101*04E E70005 DSNXRSTP M257 DPSI
    PM21910/v9-UK64303  1101*INCOR Value on FULL OJ
    PM25380/va-UK64511  1102 INCOR QUERY RUN CPU PAR CONTEXT AUTH
    PM26596/va-UK64429  1102 INCOR DB2 I/O PAR for CATALOG/DIRECTORY
    PM27253/UK63993-994-992 1102 INCOR VALUE OUTERJ TABLEX Sideways
    PM25451/UK65585-586-584 1103* INCOR NRF QUERY INLIST
    PM30829/v9-UK65583-582  1103*SQLC-413 UDF SETFUNCTION
    PM30911/UK65809-810-808 1103 DBD LOCK ACQ'D,DYNAM STMT CACHE+Lob
    PM33205//v9-UK66696-695 1104 0C7 DSNXRTIM Order By DECFLOAT Col
    PM32378/UK66576-577-575 1104 Perf Search+ w/Qualifying Row EXIST
    PM35901/UK67401,400 X1105 Incor 0 QWHSSTCK ROLLUP ACCTG RECORD
    PM34775/UK68459,UK68460 1106 04E E70005 DSNXRFF:M931 SUBSTR()=?
    PM36871/v10-UK68812X1106 Multi04E C200B0 DSNB1REL+0318 Workfiles
    PM37836/v9-UK67877-876 1106 Incor Display THD(*) Service(Wait)
    PM41474/V10-      XNRQ 04E C200B0 DSNB1REL+0318 C9010E DSNXPDST+
    PM36519/v10-UK68953 X1107 04E E70005 DSNXRSTP:M254,M261 PGD Part
    PM39194/v10-UK68877 X1107 QWHSSTCK=0 SYSPLEX QRY,ASSIST ROLLUP
    PM36512/UK69739-740-741 1107 0C7 DSNXRTIM+5400 Complex Qry
    PM37599/v9-UK69651-650  1107 0C4-RC04 DSNIWNPR+01F4
    PM38935/v9-UK69793-792 1107 Perf Add ListPF >RScan RIDPOOL OVERF
    PM39006/UK69870-871 1108 04E C90101 DSNIOST2:5001 RLF DisablePAR
    PM42066/UK70085-86-83 1108 INCOR 2Few PARAMDEG >1, Multi-Col SMJ
    PM36266/v10-UK70507 1108 04E E72018 DSNXSINE+311C Multi-OJ
    PM39035/v9-UK70851-850 1108 04E C90301 DSNITCUS+264A par/child+
    PM39122/UK69475-476-474 1108 04E E70005 DSNXRFF:M931
    PM39051/v9-UK70117-116 X1108 04E C90101 DSNTIWNPR:5008 Workfile
    PM40699/v9-UK70072-071 1108 PAR THREAD HUNG,RESUME BY PAR TASK
    PM41582/v9-UK70552-551 1108 INCOR PART INNER TABLE&PAR GRPBY
    PM39087/v9-UK71263-262 1109 04E C90101 DSNIPSBL:5003 Qry CP
    PM43740/UK71916-915  1109 04E E70005 DSNXGDT2:M201 Count,Union+
    PM29906/v10-UK72634  1110 SQLC-20143 DSNXRSBC ACCESSING ENCRYPT
    PM44938/v10-UK72025  1110 04E E70005 DSNXORLI:P008 INLINE LOB
    PM46400/UK72559-558  1110 THREAD LOOP DSNTTSPD DSNTTSAT DSNXPRE3
    PM46702/UK73242-241  1111 04E E70005 DSNXVTRS:M420 IF CASEX OBY
    PM45863/UK73311-310  1111*04E E20027 DSNSVBK+0A02 CPU PAR TASK
    PM52129/UK74771-772  1112*CRASH*0C1 RC01 CANCEL SUSP IRLM THREAD
    .
    PM49532/v10-UK74876  12nn 04E E72018 DSNXSZK+2DBA, MERGC='Y'+
    PM51077/        -    12nn INCOR RNF SortGrp Repeats,CACHEDYN=YES
    PM50451/        -    OPEN DSNXSBUC+08EE PAR Qry GBy
    PM51848/        -   XOPEN 04E C90101 DSNIWNPR:500A transfer wkfl
    PM52445/        -    OPEN 0C4 RC3B DSNXECL+11DE , Cleanup
    PM53042/        -    OPEN PERF ENHANCE CP PAR SERVICEABILITY
    .
    .
    

Local fix

  • R610 R710 R810 R910 RA10
    

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    II12836

  • 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

    2001-04-05

  • Closed date

  • Last modified date

    2012-09-06

  • 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:
06 September 2012