KevinHarrison 1000005N52 Visits (990)
LOB integrity abend during REORG of DBD01. Fix - PM66874,
Issue with catalog/directory space growth. FIX - PM64226 resolve for LOBs only!
For the base SPT01 growth Fix in separate APAR PM74659 not available - this will take some time!
Unformatted pages in SYSDBDXA directory LOB resulting in abends. No broken LOB data. REORG of tablespace to correct. APAR PM64226 to resolve.
Directory LOB extend failure. Fixed with APAR PM66874
REORG abend. Broken aux index. Fixed with APAR PM68842
KevinHarrison 1000005N52 Visits (874)
KevinHarrison 1000005N52 Visits (806)
PM77111: SERVICEABILITY ENHANCEMENT PROVIDING NEW IFCID FOR RIDPOOL FULL CONDITION
This is currently still open
KevinHarrison 1000005N52 Visits (648)
PM75711: SERVICEABILITY ENHANCEMENT TO PROVIDE DIAGNOSTIC LOGGING FOR UNEXPECTED PBG GROWTH ISSUE.
This PMR is still open, but should be monitored
flodubois 270000K6H5 Visits (826)
If you want to REORG a LOB tablespace then you can just REORG that LOB tablespace. If you want to run REORG on the base tablespace using AUX YES - this will work fine, but if you are doing this against a compressed SPT01 then make sure you do not also specify KEEPDICTIONARY until you have the PTF fix on for APAR PM67696.
flodubois 270000K6H5 Visits (790)
Q. If PIECESIZE is specified at maximum of 64GB and (LARGE or DSSIZE x is specified on tablespace), then is the maximum pageset size going to be 64GB*4096 parts =256TB?
A. The number of index data sets is influenced by the number of data partitions. Initially using PIECESIZE of 64GB you could not index 128TB of data using DSSIZE 128 GB or 256 GB due to the reduced number of index data sets. APAR PM42175 was created to allow the specification of 128 GB and 256 GB PIECESIZE.
Specification of 64GB is only allowed when the number of data partitions (derived from DSSIZE) is less than the following maximum data parts.
Chart for 128GB PIECESIZE
Chart for 256GB PIECESIZE
Q. Now that DB2 can support a DSSIZE of 256GB for tablespace what is the new max size for the NPI?
Q. Is the only way to influence it - by increasing DSSIZE for the tablespace?
Q. Is there a way to calculate how much is space is actual used/left to grow based on the Catalog or RTS?
flodubois 270000K6H5 Visits (1033)
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.
flodubois 270000K6H5 Visits (1016)
New Site (same URL)
(you will need an IBM ID in order to join the developerWorks community)
The DB2 for z/OS Best Practices web page has moved to a developerWorks community. This move brings with it the following features:
* Video content is streamed from YouTube with HD quality possible.
* From YouTube you can download video to your disk.
* The site allows you to comment on individual Best Practices.
* You can still download transcripts and slides of presentations from the site.
* Content is still organized using the DB2 Roadmap with tags for each category
* Feeds and Social Media integration provided by developerWorks communities.
The one-day seminar "Recommendations from DB2 Health Check Studies" by John Campbell and Florence Dubois has been recorded in 4 parts:
* Continuous Availability
* Special Considerations for WLM, CICS, and DDF
* Speed of Recovery
A popular presentation on writing SQL for improved performance is presented by Tom Beavin:
* SQL Performance (Part 1 & 2)
Best practices for achieving stability in your DB2 access paths is presented by Tom Beavin:
* Achieving Access Path Stability (Part 1 & 2)
Michael_D. 1100004WAH Visits (651)
Michael_D. 1100004WAH Visits (698)
Michael_D. 1100004WAH Visits (704)
HELP WITH HANDLING THE RELEASE INCOMPATIBLE CHANGE FOR VARCHAR( DECIMAL), CAST (DECIMAL AS CHAR), CAST(DECIMAL AS VARCHAR)
Michael_D. 1100004WAH Visits (3255)
In Version 10, the formatting of decimal data has changed for the VARCHAR function and the CAST specification with decimal input and VARCHAR or CHAR output. There are two changes:
- Remove leading zero
Michael_D. 1100004WAH Visits (775)
agburke 060001QPDN Visits (976)
I wanted to remind everyone that there is a very comprehensive website in developerworks that lists best practices for many topics from LOBs, to Utilities, to stored procedures.
The content includes downloadable presentations as well as pre-recorded webcasts so that you can walk through the slides as the moderator is presenting.
Here is the URL and a screen shot of the Monitoring and Tuning port
agburke 060001QPDN Visits (841)
As many of you know IBM has changed the products that come in the DB2 Accessories Suite.
At one point we had the DB2 Management Clients Package which contained Visual Explain and Control Center, and anything that would be installed on your desktop.
Starting in DB2 9 for z/OS we changed it to the DB2 Accessories Suite which included things like Optimization Service Center, OmniFind Text search, and Spatial Support. Within that same release we deprecated OSC, and with DB2 10 for z/OS the Accessories Suite included only the spatial support and international Unicode support (ICU).
The link below breaks down which products appear in which release of the Accessories Suite, and relates it to the appropriate release of DB2.
URL for II14
Program Directory: V02.02.00
Program Number: 5697-Q02
FMIDs H2AF210, J2AG210 for use with z/OS <is the same, it has
IBM DB2 Accessories Suite for z/OS, V2.2 (5697-Q02) consists
of three features, each bundling components designed to
enhance your use of DB2 for z/OS. Component changes in this
o IBM SPSS Modeler Server Scoring Adapter for DB2 on z/OS
o IBM Data Studio V3.1.1
o IBM Text Search for DB2 for z/OS, which replaces IBM
Omnifind Text Search Server for DB2 for z/OS
o IBM Installable Information Management Software for z/OS
Solutions Information Center