Updates to DB2 Administration Tool for z/OS V11.1 User's Guide

Product documentation


Abstract

Updates that apply to DB2 Administration Tool for z/OS V11.1 User's Guide (SC19-4134-03)

Content

The most recent update is listed first.




Table of Contents

Update 1: October 30, 2014




Update 1
Date of change: October 30, 2014

Topic: Generic ignore field specifications
Change description: Added the PBG_NUMPARTS ignore specification

Start of changeIf you specify the PBG_NUMPARTS generic ignore specification, the following DB2 catalog table field is ignored: SYSTABLESPACE.PARTITIONS. End of change


Topic: Supported SQL statements (OC), Generating SQL to recreate a DB2 object (Admin), Creating native SQL procedures (Admin)
Change description: Added update about generated statement terminator

Start of changeThe generated statement terminator was ? (question mark) for releases earlier than DB2 Admin Version 11.1 and is the ` (grave accent) for DB2 Admin Version 11.1 and later releases. End of change

Topic: Option K. Packages
Change description: Enhanced readability of SQL statements in Package information through DET - Displays the Detail Package report for the selected packages

The following figure shows the SQL information section with the Package information section collapsed.

Figure 6. Details for object(s) (ADBPD)
ADBPD                  DSNA Details for object(s)                          
Command ===>                                                  Scroll ===> PAGE

Commands: SAVE  ZOOM                                                          
                                                                             
_ Details for package : SPADJB009012345678901(*1) in collection : SCADJB009(*2)
                                                                             
_  Package information                                                        
_  SQL statements in package: SCADJB00901234567890.SPADJB009012345678901234(*3)
                                                                             
_   SQL in statement: 39                                                      
_   Explain information for SQL statement: 39                                  
_   SQL in statement: 39                                                      
_   SQL in statement: 40                                                      
_   SQL in statement: 42                                              
     
INSERT INTO SCADJB00.TBADJB00 (ORDER_WAREHOUSE_ID) VALUES ('EEE')                                                                               
                                                                               
_   Explain information for SQL statement: 42                                  
                                                                             
    The operation is INSERT, UPDATE or DELETE.                                
    Inner join or no join.                                                    
    --------------------------------------------------------------------------
    Table Schema . . . : SCADJB00      Table Name . . . . : TBADJB00          
    Query number . . . : 42            Access type  . . . :                  
    Plan number  . . . : 0             Query block no . . : 1                
    Match columns  . . : 0                                                    
                                                                                   
_   SQL in statement: 39                                                      
   CLOSE                                                                      
    C1                                                                      
                                                                                   
_______________________________________________________________________________
                                                                                   
_ Long names legend                                                            
                                                                                   
 (*1) - SPADJB00901234567890123456E                                          
 (*2) - SCADJB00901234567890                                                  
 (*3) - SCADJB00901234567890.SPADJB00901234567890123456E.MYVERSION


Start of changeSQL statements are presented in 72 byte line lengths. If a statement contains host variables, the variable name and data type are displayed on separate, new lines.End of change

Topic: Option K. Packages
Change description: Two new commands available from the Packages panel (ADB21K): EXPLAIN and PLANTAB

Viewing extracted SQL for a package

Use the SQ line command (show SQL) on the Packages panel to display the Extracted SQL panel, as shown in the following figure.

The Extracted SQL panel displays the SQL statements in a package.

Figure 8. Extracted SQL panel (ADB21KSE)
ADB21KSE  ----------------- Extracted SQL ---------------- Columns 00001 00072
Command ===>                                                  Scroll ===> CSR

****** ***************************** Top of Data *****************************
==MSG> Use primary command "EXPLAIN" to explain or PLANTAB to display the    
==MSG> explain rows for the selected SQL statement using line command "C" or  
==MSG> block line command "CC".                                              
==MSG>                                                                        
=NOTE= -- SQL statements in  PACKAGE  : ADBB1PAR.ADB2REM.(V11.1.0.0000000)    
=NOTE= -- SQL in stmt:   3041 (Stmt id:589559)                                
000001 SET :H = GETVARIABLE ('SYSIBM.PLAN_NAME', 'D_PLNAME' )                
=NOTE= -- SQL in stmt:   3048 (Stmt id:589560)                                
000002 SET :H = GETVARIABLE ('SYSIBM.PACKAGE_SCHEMA', 'D_PKSCH' )              
****** **************************** Bottom of Data ****************************


The following primary commands are valid on this panel:

Start of changeEXPLAINEnd of change
Start of changeExplains the selected SQL statement when you issue the C line command or the CC block line command. Navigates to EXPLAIN panel ADB2EL.End of change
Start of changePLANTABEnd of change
Start of changeDisplays explain rows for the selected SQL statement when you issue the C line command or the CC block line command. Navigates to EXPLAIN panel ADB2ELEnd of change


Topic: Generating SQL to re-create a DB2 object and Creating native SQL procedures (PMR 40921)
Change description: The generated statement terminator changed.

Start of changeThe generated statement terminator was ? (question mark) for releases earlier than DB2 Admin Version 11.1 and is the ` (grave accent) for DB2 Admin Version 11.1 and later releases.End of change

Topic: DB2 Admin primary commands
Change description: The DUTIL is primary command.


Start of changeDUTIL End of change Start of change End of change Start of changeDisplays the Display or Terminate Utilities panel (ADB2Z2U2). On the panel, you can view a list of utilities that are running and select utilities to stop running. End of change

Topic: Utility Template panel
Change description: Add new field 'Device type' to identify whether the UNIT is on a removable device.

Figure 1. Utility Template panel (ADB25TE)
DB2 Admin -------------------- DB2X Utility Template -------------------- 11:20
Command ===>                                                                  
                                                                               
Enter name and optional remark.  Press Enter to save.                          
                                                                               
TEMPLATE . . . .            (Template name)                                    
Remark . . . . .                                                              
                                                                              >
Common options:                                                                
  UNIT . . . . .            (Device number, type or group name)                
 
Start of change Device type  .            (DASD or TAPE, default is DASD) End of change                    
  DSN  . . . . .                                                              
                                                                                                                                                             
  Change other common options  . .     (Yes/No)                                
  Change disk options  . . . . . .     (Yes/No)                                
  Change tape options  . . . . . .     (Yes/No)                                
                                                                               
Statement  . . . TEMPLATE                          
                           
.

.
.
Start of changeDevice type End of change
Start of changeUse this field to specify the device type for the data set. End of change                                                            
Topic: Parameter definitions: Change Management batch interface (APAR 39045)
Change description: Add new field 'Device type' to identify whether the UNIT is on a removable device.

Start of changeutil_template_workddn1_devtype End of change
Start of changeThe util_template_workddn1_devtype parameter specifies whether the WORKDDN1 template is on a tape-like device, or on a DASD device.
Values:
TAPE
A removal media device, such as 3490 tape, or a 3490E tape drive.
DASD
A magnetic disk storage device, such as a direct access storage device (DASD).
Default:
blank
End of change

Start of changeutil_template_errddn_devtype End of change
Start of changeThe util_template_errddn_devtype parameter specifies whether the ERRDDN template is on a tape-like device, or on a DASD device.
Values:
TAPE
A removal media device, such as 3490 tape, or a 3490E tape drive.
DASD
A magnetic disk storage device, such as a direct access storage device (DASD).
Default:
blank
End of change

Start of changeutil_template_mapddn_devtype End of change
Start of changeThe util_template_mapddn_devtype parameter specifies whether the MAPDDN template is on a tape-like device, or on a DASD device.
Values:
TAPE
A removal media device, such as 3490 tape, or a 3490E tape drive.
DASD
A magnetic disk storage device, such as a direct access storage device (DASD).
Default:
blank
End of change

Start of changeutil_template_workddn1_devtype End of change
Start of changeThe util_template_workddn1_devtype parameter specifies whether the WORKDDN1 template is on a tape-like device, or on a DASD device.
Values:
TAPE
A removal media device, such as 3490 tape, or a 3490E tape drive.
DASD
A magnetic disk storage device, such as a direct access storage device (DASD).
Default:
blank
End of change

Start of changeutil_template_workddn2_devtype End of change
Start of changeThe util_template_workddn2_devtype parameter specifies whether the WORKDDN2 template is on a tape-like device, or on a DASD device.
Values:
TAPE
A removal media device, such as 3490 tape, or a 3490E tape drive.
DASD
A magnetic disk storage device, such as a direct access storage device (DASD).
Default:
blank
End of change

Topic: Generic ignore field specifications
Change description: Added the PBG_NUMPARTS ignore specification

The generic ignore specifications are:
  • Bufferpool
  • Space
  • Storage
  • Partitioning
  • Start of changeKey targetsEnd of change
  • Start of changeBusiness timeEnd of change
  • Start of changeSystem timeEnd of change
  • Source pending changes
  • Row permissions
  • Column masks
  • Include columns
  • Start of changePBG numpartsEnd of change
  • Start of changeHash organizationEnd of change
  • XML modifier
.
.
.
Start of changeIf you specify the PBG_NUMPARTS generic ignore specification, the following DB2 catalog table field is ignored: SYSTABLESPACE.PARTITIONS. End of change

Topic: Migrating DB2 objects, data, views, and catalog statistics, Step 1. Specify the objects to migrate or clone
Change description: Provide a new option on MIG View panel ADBP8MV to prompt a "GEN-like" panel with provision to specify which object types to include/exclude from the MIG process

Start of change
Example

The starting point for migrating objects can be databases, table spaces, or tables. Issue the MIG primary command from the Database panel (ADB21D), Table Spaces panel (ADB28S) or Table panel (ADB21T).

You can specify object types that you want to include or exclude from the migration by using the GEN option.
Figure 1. Migrate Parameters panel (ADB28M)Start of change
ADB28M in ------------------- DB2X Migrate Parameters ------------------- 09:58
Option ===> GEN                                                                
                                                                               
Please specify the following for DB2 Admin Migrate:      DB2 System: DSNA      
                                                         DB2 SQL ID: ISTJE    
                                                                   More:     +
Worklist name . . . . . . .            (also used as middle qualifier in DSNs)
                                                                               
Data set information:                                                          
  PDS for jobs  . . . . . .   MYMIGR.JCL                                      
  Prefix for datasets . . .   ISTJE                                            
                                                                               
Target system parameters:                                                      
  DB2 subsystem id (SSID) .   DB2X        DB2 release  . . . . : 1101          
  Target system node name .               Submit job at local. : NO  (Yes/No)  
  DB2 sample pgm load lib .   DBS.DSN110.RUNLIB.LOAD                          
  Target JCL job data sets for Admin and DB2                                  
    Use customization settings for Admin libs . . . . . NO  (Yes/No)          
    Use customization settings for the following libs . NO  (Yes/No)          
      DB2 Admin APF library . .                                                
      DB2 exit library  . . . .                                                
      DB2 load library  . . .   SYS1.DSNDB2X.SDSNLOAD                          
  Catalog statistics options:                                                  
    Catalog qualifier . . . . . HI          >  (default SYSIBM)                
    Statistics tables . . . . . SELECT         (All or Select. Default is All)
                                                                               
Migrate options:                                                              
  Generate MIG jobs in batch  . . .   NO       (Yes/No)                        
  Generate work stmt list . . . . .   NO       (Yes/No)                        
  Combine job steps . . . . . . . .   YES      (Yes/No, Yes if HPU Unload)    
    Member prefix for combined jobs   ADBMG    (default ADBMG )                
  Scope of migrate:                                                            
    DDL . . . . . . . . . . . . . .   N        (Yes/No)                        
    Data  . . . . . . . . . . . . .   N        (Yes/No)                        
    Catalog statistics  . . . . . .   N        (Yes/No)                        
  DROP on target before CREATE  . .   NO       (Yes/No,No if scope DDL is NO)  
  Unload method . . . . . . . . . .   U        (U - Unload, H - HPU, C - Cross)
  Parallel utilities  . . . . . . .   NO       (Yes/No)                        
                                                                               
Optional steps after reload:                                                  
  Run CHECK DATA  . . . . . . . . . : NO       (Yes/No)                        
  Run RUNSTATS  . . . . . . . . . . : NO       (Yes/No)                      
  Run IMAGE COPY  . . . . . . . . . : NO       (Yes/No)                      
  Run REBIND  . . . . . . . . . . . : NO       (Yes/No)                      
                                                                             
Utility control options:                                                    
  Generate template statements  . . :          (Yes/No)                      
  Use customized utility options  . :          (Yes/No)                      
                                                                             
BP  - Change batch job parameters                                            
TU  - Specify template usage                                                  
UO  - Customize utility options                                              
Start of changeGEN - GEN optionsEnd of change                       

Publication number

SC19-4134-03

Copyright date

2014

Original publication date

2014/3/31

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 Tools for z/OS
DB2 Administration Tool

Software version:

11.1.0

Operating system(s):

z/OS

Reference #:

7041314

Modified date:

2014-10-29

Translate my page

Machine Translation

Content navigation