Summarize

COVER         Book Cover 

NOTICES       Notices 

EDITION       Edition Notice 

CONTENTS      Table of Contents 

FIGURES       Figures 

TABLES        Tables 

PREFACE       About this book 
PREFACE.1     Who should read this book 
PREFACE.2     Conventions and terminology used in this book 
PREFACE.3     How to read the syntax diagrams 
PREFACE.4     Accessibility 
PREFACE.5     How to send your comments 

CHANGES       Summary of changes to this book 

1.0            Section 1. Introduction 

1.1           Chapter 1-1. Basic information about the DB2 utilities 
1.1.1         Types of DB2 utilities 
1.1.2         Privileges and authorization IDs 
1.1.3         Utilities that can be run on declared temporary tables 
1.1.4         The effect of utilities on objects that have the DEFINE NO attribute 
1.1.5         The effect of utilities on encrypted data 

1.2           Chapter 1-2. DB2 utilities packaging 
1.2.1         SMP/E jobs for DB2 utility products 
1.2.2         The operation of DB2 utilities in a mixed-release data sharing environment 

2.0           Section 2. DB2 online utilities 

2.1           Chapter 2-1. Invoking DB2 online utilities 
2.1.1         Creating utility control statements 
2.1.2         Data sets that online utilities use 
2.1.3         Required authorizations for invoking online utilities on tables that have multilevel security with row-level granularity 
2.1.4         Using the DB2 Utilities panel in DB2I 
2.1.5         Using the DSNU CLIST command in TSO 
2.1.6         Using the supplied JCL procedure (DSNUPROC) 
2.1.7         Creating the JCL data set yourself by using the EXEC statement 

2.2           Chapter 2-2. Monitoring and controlling online utilities 
2.2.1         Monitoring utilities with the DISPLAY UTILITY command 
2.2.2         Running utilities concurrently 
2.2.3         Running online utilities in a data sharing environment 
2.2.4         Terminating an online utility with the TERM UTILITY command 
2.2.5         Restarting an online utility 

2.3           Chapter 2-3. BACKUP SYSTEM 
2.3.1         Syntax and options of the BACKUP SYSTEM control statement 
2.3.2         Instructions for running BACKUP SYSTEM 
2.3.3         Concurrency and compatibility for BACKUP SYSTEM 
2.3.4         Sample BACKUP SYSTEM control statements 

2.4           Chapter 2-4. CATENFM 

2.5           Chapter 2-5. CATMAINT 

2.6           Chapter 2-6. CHECK DATA 
2.6.1         Syntax and options of the CHECK DATA control statement 
2.6.2         Instructions for running CHECK DATA 
2.6.3         Concurrency and compatibility for CHECK DATA 
2.6.4         Sample CHECK DATA control statements 

2.7           Chapter 2-7. CHECK INDEX 
2.7.1         Syntax and options of the CHECK INDEX control statement 
2.7.2         Instructions for running CHECK INDEX 
2.7.3         Concurrency and compatibility for CHECK INDEX 
2.7.4         Sample CHECK INDEX control statements 

2.8           Chapter 2-8. CHECK LOB 
2.8.1         Syntax and options of the CHECK LOB control statement 
2.8.2         Instructions for running CHECK LOB 
2.8.3         Concurrency and compatibility for CHECK LOB 
2.8.4         Sample CHECK LOB control statements 

2.9           Chapter 2-9. COPY 
2.9.1         Syntax and options of the COPY control statement 
2.9.2         Instructions for running COPY 
2.9.3         Concurrency and compatibility for COPY 
2.9.4         Sample COPY control statements 

2.10          Chapter 2-10. COPYTOCOPY 
2.10.1        Syntax and options of the COPYTOCOPY control statement 
2.10.2        Instructions for running COPYTOCOPY 
2.10.3        Concurrency and compatibility for COPYTOCOPY 
2.10.4        Sample COPYTOCOPY control statements 

2.11          Chapter 2-11. DIAGNOSE 
2.11.1        Syntax and options of the DIAGNOSE control statement 
2.11.2        Instructions for running DIAGNOSE 
2.11.3        Concurrency and compatibility for DIAGNOSE 
2.11.4        Sample DIAGNOSE control statements 

2.12          Chapter 2-12. EXEC SQL 
2.12.1        Syntax and options of the EXEC SQL control statement 
2.12.2        Terminating or restarting EXEC SQL 
2.12.3        Concurrency and compatibility for EXEC SQL 
2.12.4        Sample EXEC SQL control statements 

2.13          Chapter 2-13. LISTDEF 
2.13.1        Syntax and options of the LISTDEF control statement 
2.13.2        Instructions for using LISTDEF 
2.13.3        Concurrency and compatibility for LISTDEF 
2.13.4        Sample LISTDEF control statements 

2.14          Chapter 2-14. LOAD 
2.14.1        Syntax and options of the LOAD control statement 
2.14.2        Instructions for running LOAD 
2.14.3        Concurrency and compatibility for LOAD 
2.14.4        After running LOAD 
2.14.5        Effects of running LOAD 
2.14.6        Sample LOAD control statements 

2.15          Chapter 2-15. MERGECOPY 
2.15.1        Syntax and options of the MERGECOPY control statement 
2.15.2        Instructions for running MERGECOPY 
2.15.3        Concurrency and compatibility for MERGECOPY 
2.15.4        Sample MERGECOPY control statements 

2.16          Chapter 2-16. MODIFY RECOVERY 
2.16.1        Syntax and options of the MODIFY RECOVERY control statement 
2.16.2        Instructions for running MODIFY RECOVERY 
2.16.3        Concurrency and compatibility for MODIFY RECOVERY 
2.16.4        The effect of MODIFY RECOVERY on version numbers 
2.16.5        Sample MODIFY RECOVERY control statements 

2.17          Chapter 2-17. MODIFY STATISTICS 
2.17.1        Syntax and options of the MODIFY STATISTICS control statement 
2.17.2        Instructions for running MODIFY STATISTICS 
2.17.3        Concurrency and compatibility for MODIFY STATISTICS 
2.17.4        Sample MODIFY STATISTICS control statements 

2.18          Chapter 2-18. OPTIONS 
2.18.1        Syntax and options of the OPTIONS control statement 
2.18.2        Instructions for using OPTIONS 
2.18.3        Concurrency and compatibility for OPTIONS 
2.18.4        Sample OPTIONS control statements 

2.19          Chapter 2-19. QUIESCE 
2.19.1        Syntax and options of the QUIESCE control statement 
2.19.2        Instructions for running QUIESCE 
2.19.3        Concurrency and compatibility for QUIESCE 
2.19.4        Sample QUIESCE control statements 

2.20          Chapter 2-20. REBUILD INDEX 
2.20.1        Syntax and options of the REBUILD INDEX control statement 
2.20.2        Instructions for running REBUILD INDEX 
2.20.3        Concurrency and compatibility for REBUILD INDEX 
2.20.4        The effect of REBUILD INDEX on index version numbers 
2.20.5        Sample REBUILD INDEX control statements 

2.21          Chapter 2-21. RECOVER 
2.21.1        Syntax and options of the RECOVER control statement 
2.21.2        Instructions for running RECOVER 
2.21.3        Terminating or restarting RECOVER 
2.21.4        Concurrency and compatibility for RECOVER 
2.21.5        Effects of running RECOVER 
2.21.6        Sample RECOVER control statements 

2.22          Chapter 2-22. REORG INDEX 
2.22.1        Syntax and options of the REORG INDEX control statement 
2.22.2        Instructions for running REORG INDEX 
2.22.3        Concurrency and compatibility for REORG INDEX 
2.22.4        Reviewing REORG INDEX output 
2.22.5        The effect of REORG INDEX on index version numbers 
2.22.6        Sample REORG INDEX control statements 

2.23          Chapter 2-23. REORG TABLESPACE 
2.23.1        Syntax and options of the REORG TABLESPACE control statement 
2.23.2        Instructions for running REORG TABLESPACE 
2.23.3        Concurrency and compatibility for REORG TABLESPACE 
2.23.4        Reviewing REORG TABLESPACE output 
2.23.5        After running REORG TABLESPACE 
2.23.6        Effects of running REORG TABLESPACE 
2.23.7        Sample REORG TABLESPACE control statements 

2.24          Chapter 2-24. REPAIR 
2.24.1        Syntax and options of the REPAIR control statement 
2.24.2        Instructions for running REPAIR 
2.24.3        Concurrency and compatibility for REPAIR 
2.24.4        Reviewing REPAIR output 
2.24.5        After running REPAIR 
2.24.6        Sample REPAIR control statements 

2.25          Chapter 2-25. REPORT 
2.25.1        Syntax and options of the REPORT control statement 
2.25.2        Instructions for running REPORT 
2.25.3        Concurrency and compatibility for REPORT 
2.25.4        Reviewing REPORT output 
2.25.5        Sample REPORT control statements 

2.26          Chapter 2-26. RESTORE SYSTEM 
2.26.1        Syntax and options of the RESTORE SYSTEM control statement 
2.26.2        Instructions for running RESTORE SYSTEM 
2.26.3        Concurrency and compatibility for RESTORE SYSTEM 
2.26.4        After running RESTORE SYSTEM 
2.26.5        Sample RESTORE SYSTEM control statements 

2.27          Chapter 2-27. RUNSTATS 
2.27.1        Syntax and options of the RUNSTATS control statement 
2.27.2        Instructions for running RUNSTATS 
2.27.3        Concurrency and compatibility for RUNSTATS 
2.27.4        Reviewing RUNSTATS output 
2.27.5        After running RUNSTATS 
2.27.6        Sample RUNSTATS control statements 

2.28          Chapter 2-28. STOSPACE 
2.28.1        Syntax and options of the STOSPACE control statement 
2.28.2        Instructions for running STOSPACE 
2.28.3        Concurrency and compatibility for STOSPACE 
2.28.4        Reviewing STOSPACE output 
2.28.5        Sample STOSPACE control statement 

2.29          Chapter 2-29. TEMPLATE 
2.29.1        Syntax and options of the TEMPLATE control statement 
2.29.2        Instructions for using TEMPLATE 
2.29.3        Concurrency and compatibility for TEMPLATE 
2.29.4        Sample TEMPLATE control statements 

2.30          Chapter 2-30. UNLOAD 
2.30.1        Syntax and options of the UNLOAD control statement 
2.30.2        Instructions for running UNLOAD 
2.30.3        Concurrency and compatibility for UNLOAD 
2.30.4        Sample UNLOAD control statements 

3.0           Section 3. DB2 Stand-alone utilities 

3.1           Chapter 3-1. Invoking stand-alone utilities 
3.1.1         Creating utility control statements 
3.1.2         Specifying options by using the JCL EXEC PARM parameter 
3.1.3          Effects of invoking stand-alone utilities on tables that have multilevel security with row-level granularity 

3.2           Chapter 3-2. DSNJCNVB 
3.2.1         Before running DSNJCNVB 
3.2.2         Running DSNJCNVB 
3.2.3         Sample DSNJCNVB control statement 
3.2.4         DSNJCNVB output 

3.3           Chapter 3-3. DSNJLOGF (preformat active log) 
3.3.1         Before running DSNJLOGF 
3.3.2         Sample DSNJLOGF control statement 
3.3.3         DSNJLOGF output 

3.4           Chapter 3-4. DSNJU003 (change log inventory) 
3.4.1         Syntax and options of the DSNJU003 control statement 
3.4.2         Before running DSNJU003 
3.4.3         Using DSNJU003 to modify the BSDS 
3.4.4         Sample DSNJU003 control statements 

3.5           Chapter 3-5. DSNJU004 (print log map) 
3.5.1         Syntax and options of the DSNJU004 control statement 
3.5.2         Before running DSNJU004 
3.5.3         Sample DSNJU004 control statement 
3.5.4         DSNJU004 (print log map) output 

3.6           Chapter 3-6. DSN1CHKR 
3.6.1         Syntax and options of the DSN1CHKR control statement 
3.6.2         Before running DSN1CHKR 
3.6.3         Sample DSN1CHKR control statements 
3.6.4         DSN1CHKR output 

3.7           Chapter 3-7. DSN1COMP 
3.7.1         Syntax and options of the DSN1COMP control statement 
3.7.2         Before running DSN1COMP 
3.7.3         Using DSN1COMP to estimate space savings from DB2 data compression 
3.7.4         Sample DSN1COMP control statements 
3.7.5         DSN1COMP output 

3.8           Chapter 3-8. DSN1COPY 
3.8.1         Syntax and options of the DSN1COPY control statement 
3.8.2         Before running DSN1COPY 
3.8.3         Using DSN1COPY to copy data sets 
3.8.4         Sample DSN1COPY control statements 
3.8.5         DSN1COPY output 

3.9           Chapter 3-9. DSN1LOGP 
3.9.1         Syntax and options of the DSN1LOGP control statement 
3.9.2         Before running DSN1LOGP 
3.9.3         Using DSN1LOGP to format the contents of the recovery log 
3.9.4         Sample DSN1LOGP control statements 
3.9.5         DSN1LOGP output 

3.10          Chapter 3-10. DSN1PRNT 
3.10.1        Syntax and options of the DSN1PRNT control statement 
3.10.2        Before running DSN1PRNT 
3.10.3        Sample DSN1PRNT control statements 
3.10.4        DSN1PRNT output 

3.11          Chapter 3-11. DSN1SDMP 
3.11.1        Syntax and options of the DSN1SDMP control statement 
3.11.2        Before running DSN1SDMP 
3.11.3        Using DSN1SDMP to force dumps and write trace records 
3.11.4        Sample DSN1SDMP control statements 
3.11.5        DSN1SDMP output 

APPENDIX1     Appendixes 

APPENDIX1.1   Appendix A.  Limits in DB2 UDB for z/OS 

APPENDIX1.2   Appendix B.  DB2-supplied stored procedures 
APPENDIX1.2.1 Invoking utilities as a stored procedure (DSNUTILS) 
APPENDIX1.2.2 DSNUTILU stored procedure 
APPENDIX1.2.3 The Control Center table space and index information stored procedure (DSNACCQC) 
APPENDIX1.2.4 The Control Center partition information stored procedure (DSNACCAV) 
APPENDIX1.2.5 The DB2 real-time statistics stored procedure 

APPENDIX1.3   Appendix C.  Advisory or restrictive states 
APPENDIX1.3.1 Auxiliary CHECK-pending status 
APPENDIX1.3.2 Auxiliary warning status 
APPENDIX1.3.3 CHECK-pending status 
APPENDIX1.3.4 COPY-pending status 
APPENDIX1.3.5 Group buffer pool RECOVER-pending status 
APPENDIX1.3.6 Informational COPY-pending status 
APPENDIX1.3.7 REBUILD-pending status 
APPENDIX1.3.8 RECOVER-pending status 
APPENDIX1.3.9 REFRESH-pending status 
APPENDIX1.3.10 REORG-pending status 
APPENDIX1.3.11 Restart-pending status 

APPENDIX1.4   Appendix D.  Running the productivity-aid sample programs 
APPENDIX1.4.1 Running DSNTIAUL 
APPENDIX1.4.2 Running DSNTIAD 
APPENDIX1.4.3 Running DSNTEP2 and DSNTEP4 

APPENDIX1.5   Appendix E.  Real-time statistics tables 
APPENDIX1.5.1 Setting up your system for real-time statistics 
APPENDIX1.5.2 Contents of the real-time statistics tables 
APPENDIX1.5.3 Operating with real-time statistics 

APPENDIX1.6   Appendix F.  Delimited file format 
APPENDIX1.6.1 Restrictions 
APPENDIX1.6.2 Delimited data types 
APPENDIX1.6.3 Examples of delimited files 

APPENDIX1.7   Appendix G.  How to use the DB2 library 

BACK_1        Notices 
BACK_1.1      Programming interface information 
BACK_1.2      Trademarks 

GLOSSARY      Glossary 

BIBLIOGRAPHY  Bibliography 

INDEX         Index 

COMMENTS      Readers' Comments -- We'd Like to Hear from You 

IBM Library Server Copyright 1989, 2005 IBM Corporation. All rights reserved.