Start of change

Regenerating DBRMs

Db2 Admin Tool can regenerate any missing DBRMs for you based on the information in the Db2 catalog table SYSIBM.SYSPACKSTMT.

Before you begin

Requirement: You can regenerate only those DBRMs that were created by the Db2 precompiler or coprocessor for application programs that are written in the following languages:
  • ASSEMBLER
  • COBOL
  • COBOL_II
  • IBM_COBOL
  • FORTRAN
  • PL/I
  • C
  • C++
  • SQLJ
Other languages are not supported.

Procedure

To regenerate DBRMs:

  1. On the DB2 Administration Menu (ADB2) panel, specify option 1, and press Enter.
  2. On the System Catalog (ADB21) panel, specify option K (for packages), and press Enter.
  3. On the Packages (ADB21K) panel, specify the RD line command next to the package for which you want to regenerate the associated DBRM, and press Enter: 
    ADB21K in                      DC1Q Packages                Row 487 from 10001
Command ===>                                                  Scroll ===> CSR  
                                                                     More:    >
Commands:  BIND  REBIND  FREE  BINDOPT  VERSIONS  GRANT  ALL  PLANMGMT         
           DROP  DET  BET                                                    
Line commands:  
 DP - Depend  A - Auth  T - Tables  V - Views  X - Indexes      
 S - Table spaces  Y - Synonyms  Q - Sequences  RB - Rebind  F - Free  B - Bind
 ? - Show all line commands      
                                                         V I V O Quali-   R E D
S   Collection        Name     Owner    Version          D S A P fier     L X R
    VC1APAR*          *        *        *                * * * * *        * * *
--- ----------------- -------- -------- ---------------- - - - - -------- - - -
    VC1APAR           ADBTEP2  TS5784   V12.1.0.0000000  B S Y Y DEV      C N  
    VC1APAR           ADB27AC  TS5771   V12.1.0.0000000  B S Y Y SYSIBM   C N  
    VC1APAR           ADB2CON  TS5771   V12.1.0.0000000  B S Y Y SYSIBM   C N  
    VC1APAR           ADB2GET  TS5771   V12.1.0.0000000  B S Y Y SYSIBM   C N  
    VC1APAR           ADB0     TS5784   V12.1.0.0000000  B S Y Y SYSIBM   C N  
    VC1APAR           ADB27SP  DEV      V12.1.0.0000000  B S Y Y SYSIBM   C N
RD  VC1APAR           ADB2CID  DEV      V12.1.0.0000000  B S Y Y SYSIBM   C N  
    VC1APAR           ADBTEPU  TS5771   V12.1.0.0000000  B S Y Y SYSIBM   C N
  4. On the Regenerate a DBRM Member (ADBPBMRD) panel, specify where the regenerated DBRM member is to be stored. You can specify either a partitioned data set (PDS) or z/OS® UNIX System Services (USS) path name. The path name must already exist.
    Example of specifying a USS path name:
    ADBPBMRD  ------------ DC1Q Regenerate a DBRM Member ----------------- 15:09
Command ===>                                                                
                                                                            
Specify an output PDS or USS Pathname:                                      
 /u/ts5776/dbrmout                                                       + 
                                                                            
Default settings (optional):                                                
  Db2 version . .           (3, 4, 5, 6, 7, 8, 9, 10, 11, 12)               
  Language  . . .           (ASSEMBLER, COBOL, COBOL_II, IBM_COBOL, FORTRAN,
                             PL/I, C, C++, SQLJ)

    If you specify a USS path name, the package name is appended to the path name.

    Example of specifying a PDS:
    ADBPBMRD  ------------ DC1Q Regenerate a DBRM Member ----------------- 15:09
Command ===>                                                                
                                                                            
Specify an output PDS or USS Pathname:                                      
 'TS5776.DBRMOUT'                                                       + 
                                                                            
Default settings (optional):                                                
  Db2 version . .           (3, 4, 5, 6, 7, 8, 9, 10, 11, 12)               
  Language  . . .           (ASSEMBLER, COBOL, COBOL_II, IBM_COBOL, FORTRAN,
                             PL/I, C, C++, SQLJ)

    If you specify a PDS and the data set is not cataloged, you are prompted whether you want Db2 Admin Tool to create the data set for you.

    Db2 Admin Tool generates a batch job to regenerate the DBRM.

  5. Submit the generated job and ensure that it ran successfully.
End of change