timmzzz 060000RTR7 Visits (4099)
Customer X experienced Partition-By Growth (PBG) size increase with APPEND YES. Assuming the data is sparsely distributed across the PBG partitions. The following ONLINE REORG redistributed the data to the first 3 partitions. However, after the SWITCH PHASE, concurrent SQL would still append data to the last partition, leaving many partitions empty in between.
flodubois 270000K6H5 Visits (3791)
Migrating an SQL stored procedure from external to native is not as simple as a DROP/CREATE. You need to understand the release incompatibilities related to SQL stored procedures, examine your external SQL procedure source code, and make any necessary adjustments. This APAR can help you do that. It provides sample job DSNTEJ67 which initiates the process of converting source for an external SQL procedure into source for a native SQL procedure. REXX services, native SQL PL and the HOST(SQLPL) checkout precompiler are combined to extract, inspect, analyze and convert external SQL procedure source code. The appropriate set of native SQL procedure options are applied and a listing of the modified SQL procedure source code is produced.
Data Studio Query Tuning Primer & Capturing environments of SQL statements and query workloads that run on DB2 for z/OS
KevinHarrison 1000005N52 Visits (2849)
When you work with IBM Support to resolve problems that you are having when tuning queries or query workloads, you might have to send the support team a set of files that they can use to reproduce the environment in which the queries or query workloads are running.
Capturing this information is very helpful when you are
working with IBM Support to resolve a problem tuning an SQL statement or a
query workload. After you open a PMR regarding a problematic SQL statement or
query workload, IBM support technicians
The attached link explains how to collect and send these files.