Correct DSSIZE value

book

Article ID: 49194

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS CA Distributed Database Management CA Database Analyzer for DB2 for Oracle CA Database Analyzer (IMS Tools) CA Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC CA Compress Data Compression (IMS Tools) CA Database Analyzer for IMS for z/OS CA Database Copier for IMS for z/OS CA Database Organizer for IMS for z/OS CA Mainframe Extended Terminal Manager (IMS Tools) CA High Performance Recovery for IMS for z/OS CA Database Organizer (IMS Tools) CA Mainframe Program Restart Manager for IMS for z/OS CA Secondary Index Builder for IMS for z/OS CA Secondary Index for IMS for z/OS

Issue/Introduction

Issue/Problem/Symptoms: 

A user table space is defined with DSSIZE 0, by default that's 2 Gig, but somehow PDA is showing 4 gig? Why?

Resolution/Workaround:

PDAs RAIX_PIECESIZE and RATS_DSSIZE represent the TRUE dataset size. The DB2 catalog does not always. They had backward compatibility issues and such to deal with. PDA uses the real ones so that customers can rely on them. PDA defaults to the real size based on what they should end up being according to IBM doc or our testing results of what DB2 does .
I have included the IBM definitions below for an easy reference.

In the IBM v9 SQL ref Appendix. Additional information for DB2 SQL there is a table in the appendix that talks about the size of partitions (datasets).

"Maximum size of a partition (table space or index)"
For table spaces that are not defined with LARGE or a DSSIZE of 4 GB:
4 GB, for 1 to 4096 partitions . For table spaces that are defined with a DSSIZE greater than 4 GB:
64 GB, depending on the page size (for 1 to 256 partitions for 4 KB pages, for 1 to 512 partitions for 8
KB pages, for 1 to 1024 partitions for 16 KB pages, and 1 to 2048 partitions for 32 KB pages)

Environment

Release:
Component: DBA