Home Page Icon
Home Page
Table of Contents for
Examples
Close
Examples
by Cristian Molaro, Glenn McGeoch, Sabine Kaschta, Ravikumar Kalyanasundaram, Felip
DB2 11 for z/OS Technical Overview
Front cover
Figures
Tables
Examples
Notices
Trademarks
Preface
Authors
Now you can become a published author, too!
Comments welcome
Stay connected to IBM Redbooks publications
Chapter 1. DB2 11 for z/OS at a glance
1.1 Subsystem
1.2 Application functions
1.3 Operations and performance
Part 1 Subsystem
Chapter 2. Synergy with System z
2.1 Synergy with IBM zEnterprise System
2.1.1 Faster CPU speed
2.1.2 More system capacity
2.1.3 zEC12 hardware features
2.2 Synergy with IBM System z and z/OS
2.2.1 AUTOSIZE options VPSIZEMIN and VPSIZEMAX
2.2.2 1 MB page frames for DB2 execution code
2.2.3 Improved performance of batch updates in data sharing
2.2.4 Improved usability and consistency for security administration
2.2.5 Log writing
2.3 Using zIIP speciality processors
2.4 Reduced need for REORG
2.5 DFSMS storage tiers
2.5.1 Use cases for storage tiers
2.5.2 Setup and invocation of storage tiers
2.5.3 Use cases for DB2
2.6 Additional System z enhancements
2.6.1 Enhancing DB2 BACKUP SYSTEM solution
2.6.2 z/OS DFSMS VSAM RLS for z/OS catalog support
2.6.3 DDF Synchronous Receive support
2.6.4 zEnterprise Data Compression
Chapter 3. Scalability
3.1 Extended RBA and LRSN
3.1.1 Reaching the end of the basic RBA
3.1.2 The new 10 byte RBA and LRSN
3.1.3 Considerations before converting to extended format
3.1.4 Steps for enabling the extended RBA/LRSN format
3.1.5 Converting the BSDS
3.1.6 Converting DB2 catalog and directory
3.1.7 Converting data from 6 byte to 10 byte RBA/LRSN or vice versa
3.1.8 Additional considerations regarding utilities
3.2 NOT LOGGED for declared global temporary tables
3.2.1 Syntax extension
3.2.2 Undo processing for NOT LOGGED DGTTs
3.2.3 Thread reuse
3.2.4 Sample scenarios
3.3 More open data sets (DSMAX)
3.4 PBG mapping tables to lift the 64 GB limit
3.4.1 Autonomic creation of the mapping table
3.4.2 Mapping tables up to 16 TB
Chapter 4. Availability
4.1 Online schema changes and enhanced recovery options
4.1.1 Scope of enhancements for online schema changes in DB2 11
4.1.2 How it works
4.1.3 Effect of MODIFY RECOVERY
4.1.4 Considerations for LOBs
4.1.5 Restrictions for the window between PIT recovery and REORG
4.1.6 More restrictions for PIT recovery after materializing REORG
4.1.7 Determine if a table space is eligible for PIT recovery prior to REORG
4.2 Automatic recovery of indexes from GRECP or LPL status
4.2.1 RESTORE SYSTEM after two-pass LPL/GRECP recovery has occurred
4.2.2 RECOVER INDEX after two-pass LPL/GRECP recovery has occurred
4.3 Improved availability when altering limit keys
4.3.1 Considerations for tables containing LOBs
4.3.2 LOAD REPLACE
4.3.3 RECOVER
4.4 Work file database enhancements
4.4.1 WFSTGUSE_AGENT_THRESHOLD subsystem parameter
4.4.2 WFSTGUSE_SYSTEM_THRESHOLD subsystem parameter
4.4.3 Systems programmer response to DSNI052I/DSNI053I
4.5 Governing of parallel processing of utilities
4.6 Compression dictionary availability for CDC tables
4.7 DROP column support
4.7.1 Changes to the catalog as a result of dropping a column
4.7.2 Undo a DROP COLUMN
4.7.3 Impact of DROP COLUMN on utilities
4.7.4 Impact of DROP COLUMN on applications
4.7.5 Restrictions for DROP COLUMN
4.8 Defer define object enhancements
4.9 Allow BIND, REBIND, and DDL to break-in persistent threads
4.10 Idle thread break-in
4.10.1 Improvements for DDF threads
4.10.2 Improvements for non-DDF threads
Chapter 5. Data sharing
5.1 Group buffer pool write-around protocol
5.2 Improved castout processing
5.2.1 Reduced wait time for I/O completion
5.2.2 Reduced notify message size sent to castout owners
5.2.3 More granular class castout threshold
5.3 Improved DELETE_NAME performance
5.4 Restart light with CASTOUT option
5.5 Locking enhancements
5.5.1 Conditional propagation of child Update locks to the coupling facility
5.5.2 Improved performance in handling lock waiters
5.5.3 Increase in maximum number of CF lock table entries
5.5.4 Throttle batched unlock requests
5.5.5 Improved IRLM resource hash table algorithm
5.6 Index availability and performance
5.6.1 Avoid placing indexes in RBDP state during group restart
5.6.2 Reduce synchronous log writes during index structure modifications
5.7 Group buffer pool write performance
5.8 Automatic LPL recovery at end of restart
5.9 Log record sequence number spin avoidance
Part 2 Application functions
Chapter 6. SQL
6.1 Introduction
6.2 Global variables
6.2.1 DDL and catalog information
6.2.2 Qualifying global variables
6.2.3 Global variable’s scope
6.2.4 Global variable’s naming resolution
6.3 Array data type
6.3.1 Ordinary arrays
6.3.2 Associative arrays
6.3.3 ARRAY_EXISTS predicate
6.4 Aliases and public aliases for SEQUENCES
6.4.1 Private ALIAS for a SEQUENCE
6.4.2 Public ALIAS for a SEQUENCE
6.4.3 Dropping an alias for sequence
6.4.4 Security considerations
6.4.5 Considerations regarding application compatibility setting
6.5 New built-in functions
6.5.1 ARRAY_AGG
6.5.2 ARRAY_DELETE
6.5.3 ARRAY_FIRST
6.5.4 ARRAY_LAST
6.5.5 ARRAY_NEXT
6.5.6 ARRAY_PRIOR
6.5.7 CARDINALITY
6.5.8 MAX_CARDINALITY
6.5.9 TRIM_ARRAY
6.5.10 UNNEST (table function)
6.5.11 Arrays in MERGE statement
6.6 SET CURRENT APPLICATION COMPATIBILITY
6.7 Temporal special registers
6.7.1 Scope of session-level special registers
6.7.2 SYSTIMESENSITIVE and BUSTIMESENSITIVE
6.8 Temporal support on VIEWs
6.9 DGTT
6.10 CUBE, ROLLUP and GROUPING SETS
6.10.1 GROUPING SETS
6.10.2 ROLLUP
6.10.3 CUBE
6.10.4 Grand total
6.10.5 Grouping expression
6.11 ALTER TABLE DROP COLUMN
6.12 LIKE_BLANK_INSIGNIFICANT DSNZPARM
Chapter 7. Application enablement
7.1 Ensuring application compatibility
7.2 Transparent archiving of temporal data
7.2.1 Controls of archive transparency
7.2.2 Sample code for enabling archive transparency
7.2.3 Inserting rows into archive enabled table
7.2.4 Deleting rows from an archive enabled table
7.2.5 Querying archive enabled table
7.2.6 Using a dynamic transaction with archive transparency
7.2.7 Static application scenario
7.2.8 DISABLE ARCHIVE
7.2.9 Analytics Accelerator - HPSS considerations
7.3 Providing support for big data
7.3.1 Enhancing big data analytics with Apache Hadoop
7.3.2 Example HDFS_READ with a generic table UDF
7.3.3 Example JAQL_SUBMIT
7.4 Using the scoring adapter to add predictive analytics to OLTP applications
7.5 Using JavaScript Object Notation with IBM DB2
7.6 Suppressing null indexes
Chapter 8. XML
8.1 XQuery support
8.1.1 FLWOR expressions
8.1.2 XQuery constructors
8.1.3 Conditional expressions
8.1.4 Built-in functions
8.1.5 XQuery prolog
8.2 XML performance enhancements in DB2 10 and DB2 11
8.2.1 Eliminate hotspots during XML insert
8.2.2 Validate binary XML
8.2.3 Avoid revalidation during LOAD
8.2.4 Partial revalidation
8.2.5 XMLTABLE performance improvements
8.3 XQuery FLWOR expressions performance enhancements
8.4 XMLTABLE performance enhancements in DB2 11
8.4.1 Date/Time predicate pushdown
8.4.2 Optimize index key range for varchar predicates
8.4.3 Pushdown of column casting into XPath
Chapter 9. Connectivity and administration routines
9.1 Client information enhancements
9.1.1 Expansion of the length of some Client information fields
9.1.2 Introduction the new client information field Client Correlation Token
9.1.3 Introduction of a new built-in session global variable
9.1.4 Using the client information fields
9.2 Cancel thread and cancel SQL statement improvements
9.2.1 Changes in Cancel DDF thread
9.2.2 Changes in SQL statement interruption processing
9.3 Continuous block fetching
9.4 Support for global variables
9.5 Local stored procedure execution improvement
9.6 Multi-threaded Java stored procedure environment
9.7 ADMIN_COMMAND_MVS stored procedure
9.8 Drivers, clients, and connectivity requirements
Part 3 Operations and performance
Chapter 10. Security
10.1 Enhancements for exit authorization checking
10.1.1 Use owner privileges for authorization
10.1.2 Refresh DB2 cache entries when RACF permissions change
10.2 Enhancements to program authorization
10.3 Column masking enhancements
10.3.1 Remove column access control restrictions for GROUP BY
10.3.2 Correct implementation of aggregate function with DISTINCT
10.3.3 Column access control for UNION
Chapter 11. Utilities
11.1 Online REORG enhancements
11.1.1 Improve performance of partition-level REORG with non partitioned secondary indexes
11.1.2 SWITCH phase impact reduction
11.1.3 Physically delete empty partition-by-growth partitions
11.1.4 Automated REORG mapping table management
11.1.5 REORG without SORTing data
11.1.6 Partition-level inline image copy
11.1.7 Improved REORG LISTDEF processing
11.1.8 REBALANCE enhancements
11.1.9 REORG of LOB enhancements
11.1.10 Improved REORG serviceability
11.1.11 REORG change of defaults to match preferred practices
11.2 Enhanced statistics
11.2.1 RUNSTATS RESET ACCESSPATH
11.2.2 RUNSTATS USE PROFILE usability for LISTDEF
11.3 Backup and recovery enhancements
11.3.1 SYSLGRNX recording for catalog and directory table
11.3.2 VCAT name translation for RESTORE SYSTEM
11.3.3 Remove the incompatibility of REORG and COPY
11.3.4 Removal of many point-in-time recovery restrictions
11.4 LOAD and UNLOAD enhancements
11.4.1 LOAD SHRLEVEL NONE with PARALLEL option
11.4.2 LOAD SHRLEVEL CHANGE with PARALLEL option
11.4.3 Addition of crossloader support for XML
11.4.4 More offload to zIIP with NPSIs
11.5 Compression dictionaries for Change Data Capture
11.6 General enhancements
11.6.1 DISPLAY UTILITY additional output
11.6.2 Improved TEMPLATE for extended format data sets
11.6.3 DSN1COPY
11.6.4 REPAIR utility
11.6.5 Command to externalize RTS statistics
11.6.6 DSNACCOX
11.7 Deprecated functions
Chapter 12. Installation and migration
12.1 Currency of versions and migration paths
12.2 Prerequisites for DB2 11
12.2.1 Processors
12.2.2 Auxiliary storage
12.2.3 Operational requirements
12.2.4 Optional program requirements
12.3 DB2 11 installation changes and considerations
12.3.1 More support of naming standards in install and IVP jobs
12.3.2 No more EDM calculations
12.3.3 Modified installation jobs
12.3.4 New installation job DSNTIJCB
12.3.5 Miscellaneous
12.4 Considerations for migrating to DB2 11
12.4.1 Premigration considerations
12.4.2 DB2 11 CM
12.4.3 DB2 11 ENFM and NFM
12.5 Subsystem parameters
12.5.1 New system parameters
12.5.2 Changed defaults for existing system parameters
12.5.3 Removed system parameters
12.5.4 Deprecated system parameters
12.6 Release incompatibilities
12.6.1 Application and SQL release incompatibilities
12.6.2 Utility release incompatibilities
12.6.3 Command release incompatibilities
12.6.4 Storage release incompatibilities
12.6.5 Functions that are deprecated
12.6.6 Functions that are no longer supported
12.7 Controlling application compatibility
12.7.1 Example of DB2 10 application compatibility
12.7.2 Overview of application compatibility in DB2 11
Chapter 13. Performance
13.1 Performance expectations
13.2 System level performance
13.2.1 Internal optimization
13.2.2 Logging
13.2.3 Synergy with System z
13.2.4 Buffer management
13.2.5 Data sharing
13.3 Reduced need for REORG
13.3.1 Asynchronous removal of pseudo-deleted indexes
13.3.2 Indirect reference avoidance
13.4 More opportunities for RELEASE(DEALLOCATE)
13.5 Optimizer enhancements
13.5.1 Identification of critical statistics for improved query performance
Part 4 Appendixes
Appendix A. Information about IFCID changes
A.1 New IFCIDs
A.2 Aggregate accounting overview and purpose
A.3 IFCID 53 and 58 enhancements overview
A.4 Accounting trace enhancements overview
A.5 IRLM Storage Accounting enhancement
A.6 Stored procedure monitoring overview and purpose
A.7 Other accounting changes
Appendix B. Summary of relevant maintenance
B.1 DB2 APARs
B.2 z/OS APARs
B.3 OMEGAMON PE APARs
Related publications
IBM Redbooks publications
Other publications
Online resources
Help from IBM
Back cover
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Tables
Next
Next Chapter
Notices
Examples
2-1 ALTER BUFFERPOOL command to use 2 GB frame size 10
2-2 Results of ALTER BUFFERPOOL command to change FRAMESIZE 10
2-3 DISPLAY BUFFERPOOL command to show 2 GB frame size 10
2-4 Results of DISPLAY BUFFERPOOL command showing 2 GB frame defined 10
2-5 Results of DISPLAY BUFFERPOOL command showing 2 GB and 1 MB frame allocation 11
2-6 D VIRTSTOR command to show the maximum allocation of 2 GB and 1 MB frames 12
3-1 Output of DISPLAY GROUP command 26
3-2 Ten byte RBA in MSTR in CM 27
3-3 Log record in CM 27
3-4 DSN1PRNT of a header page in extended format 28
3-5 DSN1PRNT of a header page in basic format 28
3-6 DSNJCNVT control statement 33
3-7 DSNJU004 JCL 33
3-8 DSNJU004 output showing if DSNJCNVT has run 34
3-9 Output of TEST option 41
3-10 Repair output 41
3-11 BACKUP token prior to BSDS conversion 41
3-12 BACKUP SYSTEM job output after BSDS conversion 42
3-13 DSNJU004 after BACKUP SYSTEM for non-data sharing system 42
3-14 BACK SYSTEM job output from data sharing system 42
3-15 DSNJU004 after BACKUP SYSTEM for data sharing 42
3-16 Error message for not found map table space 49
4-1 DDL for table creation 53
4-2 Selecting from SYSCOPY 55
4-3 AREOR for all three partitions of the PBR 62
4-4 WFSTGUSE per agent message 67
4-5 WFSTGUSE per system message 68
5-1 DISPLAY GROUPBUFFERPOOL output with write-around statistics 87
5-2 DISPLAY GBPOOL command output for percentage based CLASST threshold 89
5-3 ALTER GBPOOL command to express CLASST in number of pages 89
5-4 ALTER GBPOOL command output showing CLASST in number of pages 89
5-5 Syntax of MODIFY irlmproc,SET command 92
6-1 Sample create global variable statement 103
6-2 Scope of global variable: Different SQL statements on the same DB2 connection 103
6-3 Sample - Ordinary Array definition 105
6-4 Associative array data type - sample CREATE, DECLARE, and SET statements 105
6-5 ARRAY_EXISTS predicate syntax 105
6-6 Array data type create statement and sample use case in a scalar function 112
6-7 Sample invocation of UNNEST table function 114
6-8 Sample invocation of UNNEST table function with ORDINALITY clause 114
6-9 APPLICATION COMPATIBILITY - Setting the special register values 114
6-10 Sample SET CURRENT TEMPORAL BUSINESS_TIME statement 115
6-11 SET CURRENT TEMPORAL SYSTEM_TIME to past time period 115
6-12 SET CURRENT TEMPORAL SYSTEM_TIME to future time period 116
6-13 Sample temporal table DDL statements 118
6-14 Sample VIEW statement on a temporal table along with a temporal Query 119
6-15 Selecting with AS OF 120
6-16 Sample SQL statement utilizing GROUP BY GROUPING SETS 121
6-17 Sample ROLLUP construct 122
6-18 Sample ROLLUP result set 122
6-19 Selecting with grouping sets 123
6-20 Sample SQL statement using CUBE construct in a GROUP BY clause 124
6-21 Result set from the sample CUBE construct 124
6-22 LIKE BLANK INSIGNIFICANT DSNZPARM behavior with trailing blanks 128
6-23 Sample LIKE predicate to illustrate the stripping of trailing blanks 128
7-1 DDL for ARCHIVE ENABLE 132
7-2 ALTER TABLE ADD COLUMN on an archive enabled table 133
7-3 Sample INSERT statement with MOVE_TO_ARCHIVE set to N 133
7-4 Error message on an INSERT with MOVE_TO_ARCHIVE set to ' N' 133
7-5 Sample DELETE from an Archive Enabled Table 134
7-6 Sample SELECT statement on an archive enabled table 135
7-7 Sample cursor statement in a static application 135
7-8 DDL for DISABLE ARCHIVE statement 136
7-9 Sample Generic Table UDF code 144
7-10 Sample HDFS_READ from a CSV file 145
7-11 Sample JAQL_SUBMIT 145
7-12 Nested UDF calls 146
7-13 Sample SQL statement for a scoring adapter for DB2 on z/OS 148
8-1 DDL for purchaseOrdersXML table 153
8-2 DDL for statusXML table 154
8-3 INSERT statements for purchaseOrdersXML table 154
8-4 INSERT statements for statusXML table 156
8-5 Use of FLWOR “for” keyword to loop through a sequence of values 157
8-6 Results of sample XQuery using FLWOR keyword “for” 157
8-7 Sample XQuery using FLWOR keyword “for” and XMLSERIALIZE 158
8-8 Sample XQuery using all FLWOR keywords 159
8-9 Results of sample XQuery using all FLWOR keywords 159
8-10 XQuery FLWOR expression to express a join 160
8-11 Results of XQuery FLWOR expression to express a join 160
8-12 Example of an XQuery constructor 161
8-13 Sample XQuery using conditional expression 162
8-14 Results of sample XQuery using conditional expression 163
8-15 Sample XQuery using fn:avg built-in function 163
8-16 Syntax for boundary-space declaration 164
8-17 Syntax for copy namespaces declaration 164
8-18 Declaration example preserving boundary space and copy namespaces 165
8-19 Results of query to preserve boundary space and copy namespaces 165
8-20 Declaration example not preserving boundary space and copy namespaces 166
8-21 Results of query to not preserve boundary space and copy namespaces 166
8-22 Example of avoiding XML schema revalidation 167
8-23 UPDATE of an XML document with partial revalidation 168
9-1 -DIS THD(*) DETAIL 173
9-2 Retrieve the CURRENT CLIENT_CORR_TOKEN value using SQL 173
9-3 Value of CURRENT CLIENT_CORR_TOKEN 174
9-4 Client correlation token components 174
9-5 Java and CURRENT CLIENT_CORR_TOKEN 174
9-6 Java program output, overriding the correlation token 175
9-7 -DIS THD(*) DETAIL and the client correlation token value 175
9-8 DDL and Insert for example table 175
9-9 Contents of example table 176
9-10 Using the CURRENT CLIENT_CORR_TOKEN in SQL 176
9-11 Java and SQL exploiting CURRENT CLIENT_CORR_TOKEN 176
9-12 Java application execution output 177
9-13 Query on SYSIBM.SYSVARIABLES 178
9-14 OMPE command JCL example 179
9-15 OMPE Accounting Trace Long - JDBC driver 10.1 fix pack 0 180
9-16 OMPE Accounting Trace Long - JDBC driver 10.5 fix pack 2 180
9-17 JDBC driver correlation: Old Java driver 180
9-18 JDBC driver correlation: New Java driver 180
9-19 OMPE Accounting Trace report, identification section 181
9-20 DDL to create the RLMT table DSNRLMT01, DB2 11 version 183
9-21 DDL to create the RLMT table DSNRLMT01, DB2 10 version 183
9-22 Start Resource Limit Facility command 184
9-23 Successful start of RLF 184
9-24 Starting RLIMIT in DB2 10 with DSNRLMT01 version DB2 11 185
9-25 -DIS RLIMIT: RLF partially started 185
9-26 Starting RLIMIT in DB2 11 CM with DSNRLMT01 version DB2 11 185
9-27 -DIS RLIMIT: RLF partially started 186
9-28 -DIS RLIMIT output example 186
9-29 ALTER TABLE SYSIBM.DSNRLMT01 186
9-30 Copying RLMT data to a DB2 11 version of the table 186
9-31 Copying RLST data to a DB2 11 version of the table 187
9-32 -STA RLIMIT command 187
9-33 Starting RLIMIT on a new set of RLF tables 187
9-34 WLM Modify Rules for the Subsystem Type panel 192
9-35 Setting accounting information in a Java program 192
9-36 WLM classification rules: nesting accounting information 193
9-37 installing WLM definitions 193
9-38 WLM Service definition installation successful 194
9-39 Activating WLM definitions 194
9-40 WLM Policy activated 194
9-41 RMF Enclave Report panel 194
9-42 Enclave details in RMF Enclave report 195
9-43 RMF Enclave Classification Attributes 195
9-44 WLM_SET_CLIENT_INFO syntax 196
9-45 Using the setClientInfo Java method 197
9-46 Java program: setting client information fields 198
9-47 Java sample program output 200
9-48 -DIS THD(*) DETAIL 200
9-49 DIS THD(*) DETAIL and message V436 201
9-50 DIS THD(*) DETAIL and message V436 missing 201
9-51 CANCEL THREAD command in DB2 11 203
9-52 -DISPLAY THREAD(*) LOCATION(*) command 203
9-53 CANCEL DDF THREAD command syntax 203
9-54 CANCEL DDF THD FORCE example 204
9-55 DB2 11 new message DSNV519I 204
9-56 Structure of DB2 message DSNV519I 204
9-57 CANCEL DDF THREAD command 205
9-58 CANCEL THREAD command output example 205
9-59 Cancelled thread: DB2 MSTR feedback 205
9-60 JCC trace and the default interrupt processing mode 206
9-61 SPUFI panel DSNEBP11, defaults for REBIND PACKAGE 208
9-62 REBIND PACKAGE with DBPROTOCOL(DRDACBF) option 209
9-63 REBIND output 209
9-64 Structure of SQLCODE -30045 212
9-65 Syntax CALL ADMIN_COMMAND_MVS 218
9-66 Message DSNA601I 219
9-67 ADMIN_COMMAND_MVS and WLM DISPLAY: system log messages 220
9-68 RACF - GENERAL RESOURCE SERVICES panel 221
9-69 RACF SEARCH FOR GENERAL RESOURCE PROFILES panel 221
9-70 RACF COMMAND OUTPUT, MVS.MCSOPER 222
9-71 RACF COMMAND OUTPUT, resource MVS.MCSOPER.* 222
9-72 RACF define resource MVS.MCSOPER.DSNADMCM 222
9-73 RACF define resource output example 223
9-74 RACF SETROPTS REFRESH command 223
9-75 RACF resources search result 223
9-76 RACF resource MVS.MCSOPER.DSNADMCM 223
9-77 Error message DSNA628I 223
9-78 RACF message ICH408I 224
9-79 RACF PERMIT MVS.MCSOPER.DSNADMCM 224
9-80 RACF SETROPTS RACLIST(OPERCMDS) REFRESH command 224
9-81 RACF MVS.MCSOPER.DSNADMCM resource details 224
9-82 Using the db2level command 226
9-83 Running the db2jcc utility 226
9-84 Db2jcc utility output 226
9-85 JDBC connection url String with TRACE_ALL 227
9-86 JDBC trace output 227
9-87 -DIS DDF output example 230
9-88 DB2 Command Line Processor initial contents 231
9-89 DB2 catalog TCP/IP node example 231
9-90 Sample Windows hosts file 232
9-91 DB2 catalog TCP/IP node example using an hosts file entry 232
9-92 DB2 catalog TCP/IP node output example 232
9-93 DB2 terminate example 232
9-94 DB2 list node directory command example 233
9-95 DB2 catalog database command example 233
9-96 DB2 catalog database command output example 233
9-97 DB2 list database directory command output example 233
9-98 Connect to a DB2 for z/OS database using the CLP 234
9-99 DB2 catalog ODBC data source command example 235
9-100 DB2 catalog ODBC data source command output example 235
9-101 DB2 LIST ODBC DATA SOURCES command example 235
10-1 RACF permit ACCESS(READ) on CLASS(DSNR) 242
10-2 RACF PERMIT command and % generic resource character 245
10-3 RACF PERMIT DELETE command 245
10-4 SQLCODE -551 explanation and RACF changes 246
10-5 Updates to DB2 message DSNT210I 247
10-6 DSNX235I 247
10-7 DSNX236I 248
10-8 DSNX237I 249
10-9 REBIND to enable PROGAUTH 251
10-10 DDL for creating the table SYSIBM.DSNPROGAUTH 252
10-11 DSNTIJSG extract: sample INSERT in SYSIBM.DSNPROGAUTH 253
10-12 REBIND PLAN output showing PROGAUTH enabled 254
10-13 BIND PLAN DSNTIA11 in job DSNTIJTM 255
10-14 BIND PLAN DSNTIA11 output 256
10-15 SYSPLAN query to show a PLAN’s PROGAUTH value 256
10-16 SQL query on SYSIBM.SYSPACKLIST 257
10-17 SQL query on SYSIBM.SYSPACKAGE 257
10-18 INSERT SQL on SYSIBM.DSNPROGAUTH 258
10-19 SQL query on SYSIBM.DSNPROGAUTH 258
10-20 Testing program authentication with DSNTIAD 258
10-21 Program authentication preventing execution 259
10-22 Updating SYSIBM.DSNPROGAUTH to allow program execution 259
10-23 SQL query on SYSIBM.DSNPROGAUTH, ENABLED = ‘Y’ 259
10-24 Program authentication allowing execution 260
10-25 SQL to find DBNAME and TSNAME of SYSIBM.DSNPROGAUTH 260
10-26 Display status of SYSIBM.DSNPROGAUTH table space status 260
10-27 SYSIBM.DSNPROGAUTH not available prevents program execution 261
10-28 DB2 MSTR message 00C90081 261
10-29 SPUFI option AUTOCOMMIT = NO 261
10-30 SQL to update SYSIBM.DSNPROGAUTH 262
10-31 Locks on SYSIBM.DSNPROGAUTH table space 262
10-32 Program failure due to locks on SYSIBM.DSNPROGAUTH 263
10-33 Sample table and data for column mask example 263
10-34 Creating a column mask 264
10-35 Activating column access control 264
10-36 Column access control effects on SELECT 264
10-37 Deactivating column access control 265
10-38 SQLCODE -20478 265
10-39 Aggregate function with DISTINCT in SQL 266
11-1 REORG TABLESPACE PART WITH SORTNPSI YES 272
11-2 REORG TABLESPACE PART WITH SORTNPSI YES job output 273
11-3 REORG TABLESPACE PART WITH DRAIN_ALLPARTS YES 275
11-4 REORG TABLESPACE PART WITH DRAIN_ALLPARTS YES job output 275
11-5 Mapping table with the DB2 10 format and run REORG 278
11-6 Mapping table with the DB2 11 format and run REORG 279
11-7 Mapping table and run REORG 280
11-8 Database and table space format when automatically created by DB2 280
11-9 REORG TABLESPACE SHRLEVEL CHANGE SORTDATA NO RECLUSTER NO 282
11-10 REORG TABLESPACE SHRLEVEL CHANGE SORTDATA NO RECLUSTER NO job output 283
11-11 REORG TABLESPACE PART WITH INLINE IMAGE COPY 283
11-12 REORG TABLESPACE PART WITH INLINE IMAGE COPY job output 284
11-13 REORG TABLESPACE PART WITH LISTPARTS 286
11-14 REORG TABLESPACE PART WITH LISTPARTS job output 287
11-15 REORG TABLESPACE REBALANCE SHRLEVEL CHANGE 288
11-16 REORG TABLESPACE REBALANCE SHRLEVEL CHANGE job output 289
11-17 REORG LOB SHRLEVE NONE 291
11-18 REORG LOB SHRLEVE NONE job output 292
11-19 REORG SHRLEVEL CHANGE LOGRANGES NO 292
11-20 REORG SHRLEVEL CHANGE LOGRANGES NO job output 292
11-21 RUNSTATS RESET option 296
11-22 RUNSTATS RESET job output 298
11-23 RUNSTATS USE PROFILE usability for LISTDEF 298
11-24 RUNSTATS USE PROFILE usability for LISTDEF job output 298
11-25 RESTORE SYSTEM LOGONLY SWITCH VCAT 300
11-26 LOAD SHRLEVEL NONE with PARALLEL option 302
11-27 LOAD SHRLEVEL NONE with PARALLEL option job output 303
11-28 LOAD SHRLEVEL CHANGE with PARALLEL option 304
11-29 LOAD SHRLEVEL CHANGE with PARALLEL option job output 305
11-30 DISPLAY UTILITY command output 306
11-31 TEMPLATE with DSNTYPE EXTREQ and TIME LOCAL 307
12-1 Missing fallback PTF error message 335
12-2 Install and IVP jobs generated as result of ENFM installation CLIST completion 339
12-3
-DIS GROUP result from non-data-sharing subsystem 342
12-4 DSNU2902I error message 343
12-5 DSNU2902I message text 343
12-6 -DISPLAY GROUP DETAIL output 344
12-7 -DIS GROUP DETAIL output in ENFM 344
12-8 LIKE_BLANK_INSIGNIFICANT 348
12-9 Books definition 361
12-10 CAST as TIMESTAMP with APPLCOMPAT set to V10R1 365
12-11 CAST as TIMESTAMP with APPLCOMPAT set to V11R1 365
12-12 Invoke scalar function TIMESTAMP with store clock value 366
12-13 V9 result of implicit cast of decimal using CHAR function 373
12-14 V10 result of implicit cast of decimal using CHAR function 373
12-15 IFCID 366 record description 380
12-16 IFCID 376 record description 381
13-1 Enable the cleanup on all indexes 396
13-2 Disable the cleanup on all indexes 396
13-3 Disable cleanup on all indexes except on every Saturday and Sunday 396
13-4 Disable cleanup on all indexes every day from 8am to 6pm local time 397
13-5 Disable cleanup on all indexes in database RMCDB00 397
13-6 Two rows on the same level with conflicting information about Monday 397
13-7 Sample use of the new FOR UPDATE option of PCTFREE 400
A-1 New IFCID 377 to record index pseudo delete daemon cleanup 412
A-2 Changed IFCID 106 to record INDEXCLEANUP_THREADS 412
A-3 New IFCID 27 413
A-4 IFCID 2 and IFCID 3 414
A-5 New IFCID 382 and 383 to record suspend operations for parallel task 414
A-6 IFCID369 - Aggregate accounting interface details 415
A-7 IFCID0053 416
A-8 IFCID0058 416
A-9 Accounting trace enhancements filed QHWCAACE 417
A-10 Accounting trace enhancements QWACZIIP_ELIGIBLE 417
A-11 DXR100I message 418
A-12 IFCID217, IFCID225 and IFCID106 419
A-13 IFCID0380 423
A-14 QW0381 details 425
A-15 QW0497 details 425
A-16 QW0498 details 425
A-17 QW0499 details 426
A-18 CPU time that was spent running on a Specialty Engine 427
A-19 Incompatible changes for new RBA/LRSN 428
A-20 IFCID127 and IFCID 128 429
A-21 Changes IFCID 002/225 to record arrays support 431
A-22 Changes IFCID 003/239 to record autonomous transactions 432
A-23 Changes IFCID 366 to record application incompatibility 432
A-24 Changes IFCID 230/256 to record castout queue threshold 434
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset