IBM Support

DSNTIJEN was interrupted. How can I get rid of Db2 10 table spaces that remain in Db2 11 NFM?

Question & Answer


Question

DSNTIJEN clean up steps where interrupted. Although the 7 table spaces in Db2 10 are converted, some of the Db2 10 table spaces remain in my system in Db2 11 NFM. What can I do to get rid of the Db2 10 table spaces ?

Answer

The solution is to run CATENFM CONVERT INPUT CLEANUP. However, if CATENFM CONVERT INPUT CLEANUP is run when the system is in NFM, Db2 issues DSNU777I stating CANNOT CONVERT TABLE SPACE SINCE ENFM PROCESS IS NOT STARTED.

Therefore you must run DSNTIJES to revert back to ENFM*, run CATENFM CONVERT INPUT CLEANUP, and run DSNTIJNF to get into NFM again.

Complete the following steps:


1.Ensure no other UT jobs are running with the following command:


     -DISPLAY UTILITY(*)  and -TERM UTILITY(utid)

2.Run DSNTIJES:


      //***********************************************
      //* TURN OFF NEW FUNCTION MODE (RETURN TO ENFM*)
     //***********************************************
     //DSNTITC  EXEC PGM=DSNUTILB,REGION=0M,          
    //             PARM='DSN,DSNTIJES.DSNTITC'      
    //SYSPRINT  DD SYSOUT=*                          
    //UTPRINT   DD SYSOUT=*                          
    //SYSUDUMP  DD SYSOUT=*                          
    //SYSIN     DD *                                
       CATENFM ENFMON                                  
    //*        


3.Run clean up. The following cleans up DSNDB06.SYSSTR:



     //ENFM0077 EXEC PGM=DSNUTILB,REGION=0M,
    //             PARM='SSID,DSNENFM.SYSSTR'
    //SYSPRINT  DD SYSOUT=(,)
    //UTPRINT   DD SYSOUT=(,)
    //SYSUDUMP  DD SYSOUT=(,)
    //SYSIN     DD *
       CATENFM CONVERT INPUT CLEANUP
    /*


4.Run DSNTIJNF to return to NFM:


    //JOBLIB    DD DISP=SHR,                  
    //             DSN=DSN!!0.SDSNEXIT        
    //          DD DISP=SHR,                  
    //             DSN=DSN!!0.SDSNLOAD        
    //*                                      
    //*                                      
    //ENFM9700 EXEC PGM=DSNUTILB,REGION=0M,  
    //             PARM='DSN,DSNENFM.ENFM9700'
    //SYSPRINT  DD SYSOUT=*                  
    //UTPRINT   DD SYSOUT=*                  
    //SYSUDUMP  DD SYSOUT=*                  
    //SYSIN     DD *                          
      CATENFM COMPLETE                      
    //*            

[{"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"10.0;11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg22015076