Running Multiple Relases of DB2 code and cloning

Steve Carlson

Running Multiple Relases of DB2 code and cloning

I am trying to find a standard way of migrating DB2 releases from a test environment to a production environment. I also want the capability to run multiple releases in my production environment. We do not want to use steplibs. I am also trying to find a way for maintain DB2 naming standards. Currently we are using the following naming convention:

 

SYS1.DSNB10.RSUxxxx.********     where   B10 = version 11, xxxx = rsu number, and ******** = low level node name

We are also using ALIAS names for all of the DB2 system libraries, and DB2 DBATOOLS libraries: Here are a few examples:

***********************************************************
0ALIAS --------- SYS1.DBATOOLS.CLIST                      
        NONVSAM--SYS1.DSNB10.RSU1612.DBATOOLS.CLIST       
0ALIAS --------- SYS1.DBATOOLS.DBRMLIB                    
        NONVSAM--SYS1.DSNB10.RSU1612.DBATOOLS.DBRMLIB     
0ALIAS --------- SYS1.DBATOOLS.EXEC                       
        NONVSAM--SYS1.DSNB10.RSU1612.DBATOOLS.EXEC        
0ALIAS --------- SYS1.DBATOOLS.ISPLLIB                    
        NONVSAM--SYS1.DSNB10.RSU1612.DBATOOLS.ISPLLIB     
0ALIAS --------- SYS1.DBATOOLS.ISPMLIB                    
        NONVSAM--SYS1.DSNB10.RSU1612.DBATOOLS.ISPMLIB     
0ALIAS --------- SYS1.DBATOOLS.ISPPLIB                    
        NONVSAM--SYS1.DSNB10.RSU1612.DBATOOLS.ISPPLIB     
0ALIAS --------- SYS1.DBATOOLS.ISPSLIB                    
        NONVSAM--SYS1.DSNB10.RSU1612.DBATOOLS.ISPSLIB     
0ALIAS --------- SYS1.DBATOOLS.ISPTLIB                    
        NONVSAM--SYS1.DSNB10.RSU1612.DBATOOLS.ISPTLIB     
0ALIAS --------- SYS1.DBATOOLS.LINKLIB                    
        NONVSAM--SYS1.DSNB10.RSU1612.DBATOOLS.LINKLIB     
0ALIAS --------- SYS1.DBATOOLS.LOADLIB                    
        NONVSAM--SYS1.DSNB10.RSU1612.DBATOOLS.LOADLIB     

0ALIAS --------- SYS1.DB2D.DSNLOAD           
        NONVSAM--SYS1.DSNA10.RSU1511.SDSNLOAD

 

ALIAS --------- SYS1.DB2P.DBRMLIB                     
       NONVSAM--SYS1.DSNA10.RSU1511.DBRMLIB.DATA      
ALIAS --------- SYS1.DB2P.DSNEXIT                     
       NONVSAM--SYS1.DSNA10.RSU1511.DB2P.SDSNEXIT     
ALIAS --------- SYS1.DB2P.DSNLOAD                     
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNLOAD          
ALIAS --------- SYS1.DB2P.NEW.SDSNSAMP                
       NONVSAM--SYS1.DSNA10.RSU1406.DB2P.NEW.SDSNSAMP 
ALIAS --------- SYS1.DB2P.RUNLIB                      
       NONVSAM--SYS1.DSNA10.RSU1511.RUNLIB.LOAD       
ALIAS --------- SYS1.DB2P.SDSNBASE                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNBASE          
ALIAS --------- SYS1.DB2P.SDSNC.H                     
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNC.H           
ALIAS --------- SYS1.DB2P.SDSNCLST                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNCLST          
ALIAS --------- SYS1.DB2P.SDSNDBRM                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNDBRM          
ALIAS --------- SYS1.DB2P.SDSNEXIT                    
       NONVSAM--SYS1.DSNA10.RSU1511.DB2P.SDSNEXIT     
ALIAS --------- SYS1.DB2P.SDSNIVPD                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNIVPD          
ALIAS --------- SYS1.DB2P.SDSNLINK                    
       NONVSAM--SYS1.DSN910.RSU1205.SDSNLINK          
ALIAS --------- SYS1.DB2P.SDSNLOAD                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNLOAD          
ALIAS --------- SYS1.DB2P.SDSNLOD2                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNLOD2          
ALIAS --------- SYS1.DB2P.SDSNMACS                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNMACS          
ALIAS --------- SYS1.DB2P.SDSNPFPE                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNPFPE          
ALIAS --------- SYS1.DB2P.SDSNSPFM                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNSPFM          
ALIAS --------- SYS1.DB2P.SDSNSPFP                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNSPFP          
ALIAS --------- SYS1.DB2P.SDSNSPFS                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNSPFS          
ALIAS --------- SYS1.DB2P.SDSNSPFT                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDSNSPFT          
ALIAS --------- SYS1.DB2P.SDSNXML                     
       NONVSAM--SYS1.DSN910.RSU1205.SDSNXML           
ALIAS --------- SYS1.DB2P.SDXRRESL                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDXRRESL          
ALIAS --------- SYS1.DB2P.SDXRSAMP                    
       NONVSAM--SYS1.DSNA10.RSU1511.SDXRSAMP          
ALIAS --------- SYS1.DB2P.SRCLIB                      

 

 

James Campbell

Running Multiple Relases of DB2 code and cloning
(in response to Steve Carlson)
"We do not want to use steplibs."

If you do not use STEPLIBs (or, I presume, JOBLIBs), then the DB2 libraries must exist in
the LINKLIST (or LPALIB!)

If you do not want to use steplibs in application jobs ((CICS/TSO etc) side, refer to the other
thread about DSG co-existence. The same considerations for supporting multiple versions
apply.

If you do not want to use steplibs in server STCs (xxxxMSTR, xxxxDBM1, xxxxWLMy etc)
you can run only one maintenance level (let alone release) in an LPAR per IPL. (Well,
actually you could swap between maintenance levels without an IPL - but "heroic" is what
comes to mind. As in the pop song of my youth: "Billy, don't be a hero, come back and
make me your wife" - Billy was and didn't.)

James Campbell



On 30 Oct 2017 at 14:41, Steve Carlson wrote:

>
> I am trying to find a standard way of migrating DB2 releases from a test environment to a
> production environment. I also want the capability to run multiple releases in my production
> environment. We do not want to use steplibs. I am also trying to find a way for maintain DB2
> naming standards. Currently we are using the following naming convention:
>  
> SYS1.DSNB10.RSUxxxx.********     where   B10 = version 11, xxxx = rsu number, and ******** =
> low level node name
> We are also using ALIAS names for all of the DB2 system libraries, and DB2 DBATOOLS
> libraries: Here are a few examples:
> ***********************************************************
> 0ALIAS --------- SYS1.DBATOOLS.CLIST                      
>         NONVSAM--SYS1.DSNB10.RSU1612.DBATOOLS.CLIST       
<snip>
> ALIAS --------- SYS1.DB2P.DSNEXIT 
>        NONVSAM--SYS1.DSNA10.RSU1511.DB2P.SDSNEXIT     
> ALIAS --------- SYS1.DB2P.DSNLOAD                     
>        NONVSAM--SYS1.DSNA10.RSU1511.SDSNLOAD          
<rest snipped>