IBM Support

PH18141: ENHANCEMENT TO MATERIALIZE DEFINE NO TABLESPACES

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as unreproducible in next release.

Error description

  • If Db2 parameter IMPDSDEF is set to Y, implicit tablespaces are
created as DEFINE NO and related VSAM data sets are not defined.
Some recovery methods (e.g. DSN1COPY, Advanced Recover or
Redirected Recovery) do not support recovering of such objects.
Using these methods requires to change the IMPDSDEF value
manually, which is very undesirable.
With this enhancement, the product will generate additional
utility steps (LOAD REPLACE) for created DEFINE NO tablespaces
and all usual recovery methods will become available
independently of the DEFINE NO or IMPDSDEF YES values.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of Db2 Recovery Expert for z/OS        *
****************************************************************
* PROBLEM DESCRIPTION: LOAD utility will be enhanced to        *
*                      materialize related auxiliary DEFINE NO *
*                      tablespaces. ARY will generate          *
*                      additional dummy LOAD steps for DEFINE  *
*                      NO objects after the re-create.         *
*                      It is especially important for          *
*                      implicit tablespaces if system-level    *
*                      parameter IMPDSDEF is set to Y.         *
****************************************************************
* RECOMMENDATION: Apply the PTF                                *
****************************************************************
.

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • Apply the PTF

    



APAR Information




    

  • APAR number
    PH18141
    • 

  • Reported component name
    DB2 REC EXPERT
    • 

  • Reported component ID
    5697H7400
    • 

  • Reported release
    320
    • 

  • Status
    CLOSED  UR1
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2019-10-15
    • 

  • Closed date
    2020-01-14
    • 

  • Last modified date
    2020-02-04
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Modules/Macros


    

  • ARY#A001 ARY#AAPI ARY#ACIR ARY#ACIW ARY#ACON ARY#ACRD ARY#ACUP
ARY#ADIS ARY#ADSC ARY#AEXT ARY#AFMT ARY#AFRR ARY#ALCT ARY#ALEX
ARY#ALLC ARY#ALLO ARY#ALRN ARY#ALSL ARY#ALUP ARY#AMIN ARY#ASYS
ARY#AUMX ARY#AUTH ARY#AUTL ARY#BIND ARY#BKUP ARY#BRS  ARY#BSDS
ARY#BSDU ARY#BUPD ARY#CARD ARY#CBIN ARY#CDR  ARY#CHKR ARY#CID2
ARY#CIO  ARY#CLLS ARY#CMTS ARY#CNTL ARY#CPNT ARY#CPOL ARY#CSI
ARY#CSI1 ARY#CSIA ARY#CSID ARY#CVAF ARY#DHLI ARY#DSAF ARY#DSPL
ARY#DSUB ARY#DYNL ARY#ENCR ARY#ENQS ARY#ENVF ARY#FCPY ARY#GIO
ARY#HCHK ARY#HSM  ARY#ICAI ARY#ICAL ARY#ICCC ARY#ICCI ARY#IDCF
ARY#IDIO ARY#IDSA ARY#IERR ARY#IHSA ARY#IKPL ARY#IKPN ARY#ILGP
ARY#ILRA ARY#ILRS ARY#ILSA ARY#INIT ARY#IPIE ARY#IPPB ARY#IPPC
ARY#IPPD ARY#IPPH ARY#IPPL ARY#IPPN ARY#IPPS ARY#IRPL ARY#ISNA
ARY#LGAA ARY#LGAC ARY#LGAF ARY#LGAI ARY#LGAP ARY#LOGR ARY#LRD6
ARY#MAIN ARY#MDRV ARY#MFL  ARY#MGRT ARY#MIO  ARY#MLOG ARY#MMGR
ARY#MNT  ARY#MOD  ARY#MREP ARY#MTIO ARY#OBRP ARY#OIO  ARY#ONDX
ARY#OS   ARY#PDSN ARY#PEND ARY#PIO  ARY#PRNG ARY#PTV7 ARY#PTVL
ARY#QSAM ARY#RANG ARY#RBA  ARY#RBAC ARY#RE24 ARY#RESM ARY#RIO
ARY#RPRP ARY#RPTD ARY#RUNT ARY#SDB2 ARY#SGRP ARY#SMS  ARY#STAT
ARY#STB2 ARY#STUB ARY#SUBD ARY#SUBS ARY#SUBX ARY#SUPD ARY#SVOL
ARY#SYSC ARY#TUTL ARY#UTLS ARY#VERS ARY#VOLS ARY#VPRO ARY#VTC2
ARY#VTOP ARY#WRIT ARY#XMLD ARY#XMLI ARY#XMLJ ARY#XMLS ARY#XMLU
ARY#YARC ARY#YCAL ARY#YCTL ARY#YDEL ARY#YMCA ARY#YMCR ARY$$SEQ
ARY$ACCS ARY$ADM1 ARY$ADM2 ARY$ADM3 ARY$ADM4 ARY$ADM5 ARY$ADMN
ARY$ALLC ARY$APFT ARY$APMN ARY$ASTK ARY$ATGT ARY$AXIS ARY$BACD
ARY$BBLD ARY$BDSN ARY$BJOB ARY$BLDI ARY$BLDJ ARY$BPND ARY$BPRC
ARY$BPRD ARY$BPRS ARY$BPRT ARY$BPRU ARY$BPRV ARY$BREP ARY$BSAU
ARY$BTCH ARY$BUTD ARY$CARD ARY$CG00 ARY$CGAD ARY$CGGL ARY$CGSL
ARY$CGSS ARY$CGUP ARY$CGXD ARY$CMDS ARY$CORD ARY$CRMC ARY$CRMD
ARY$CRMT ARY$CRMU ARY$CRPD ARY$CRPR ARY$CRQT ARY$CRST ARY$DELT
ARY$DGRP ARY$DOF1 ARY$DPRU ARY$EQRY ARY$ERBA ARY$FQRY ARY$ICSB
ARY$IDCM ARY$IMG2 ARY$IMG3 ARY$IMGO ARY$INEX ARY$MAIN ARY$MJOP
ARY$MVOL ARY$OBJD ARY$OBJR ARY$OFF1 ARY$OFF2 ARY$OFF3 ARY$OFF4
ARY$OFF6 ARY$OPRC ARY$OPRD ARY$PARM ARY$POOL ARY$PRCL ARY$PRFD
ARY$PRFN ARY$QSNP ARY$RBAD ARY$RESO ARY$RPTD ARY$SBCV ARY$SCSI
ARY$SQLD ARY$SSAA ARY$SSAL ARY$SSBB ARY$SSBM ARY$SSBU ARY$SSCT

    



Fix information


    

  • Fixed component name
    DB2 REC EXPERT
    • 

  • Fixed component ID
    5697H7400
    • 



Applicable component levels


    

  • R320  PSY  UI67379
       UP20/02/04  P  F001
    • 



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.
    








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            30 March 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback