Maintaining Objects of Type Dataspace

This document covers the following topics:


Dataspace Maintenance Menu

The Dataspace Maintenance menu is called with function code M and object code DC in a Predict main menu or the command MAINTAIN DATASPACE.

    13:34:10             *****  P R E D I C T  *****             2007-05-31
    Plan   0               - (DC) Dataspace Maintenance -              Profile HNO
   
     Function                              Function
   
     A  Add a Dataspace                    D  Display Dataspace
     C  Copy Dataspace                     L  Link children
     M  Modify Dataspace                   S  Select Dataspace from a list
     N  Rename Dataspace                   J  Physical Attributes 
     P  Purge Dataspace                    
   
   
    Function .........
   
    Dataspace ID .....                                  Attributes ....* 
    Copy ID ..........
    Located in DA ....
   
    Restrictions ....*   Profile HNO ,used              Association ...*
   
    Command ===>
   
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Next  Stop  Last  LnkEl Flip  Print Impl  AdmFi SelFi Prof  Next
  

Note:
Parameters not listed here are described under Global Attributes.

Parameters
Function Executes one of the maintenance functions.
Standard maintenance functions are described in the section Maintenance in the Predict Reference documentation.
The function Purge is described in the section Dataspace-Specific Maintenance.

Adding a Dataspace

The following screen is displayed for the Add a Dataspace function.

    13:00:49             *****  P R E D I C T  *****            2007-05-31
                                - Add a Dataspace -
    Dataspace ID .... HNO-DC
   
   
   
   
   
   
            Dataspace type ....* D DB2
            Located in DA .....*
   
  
Parameters
Dataspace type
D DB2 mainframe
S SQL/DS
2 DB2 open systems
A second input screen is displayed depending on the type. The screens are described below.
Located in DA The ID of the database which contains the dataspace. Applicable to DB2 dataspaces.

Defining Basic Attributes of Dataspace - DB2 Mainframe

The following screen applies to DB2 mainframe dataspaces (type D).

 14:49:02             *****  P R E D I C T  *****                     2009-07-31
                             - Add a Dataspace -                                
 Dataspace ID .... HNO-DC                                                       
 Type ............ DB2 mainframe                                                
 Located in DA ... DB2-V9                                                       
 Keys ..                                                                 Zoom: N
                                                                                
 Dataspace attributes                                                           
   Tablespace name ..                                                           
 Physical attributes in DADB29                           (new)                  
   Type ............*   Simple                 Member cluster .... Y (Y,N)      
   Nr of partitions .                          Large ............. N (Y,N)      
   Buffer pool .....*                          Partition size ...*              
   Locksize ........* P                        Pages per segment .              
   Close option .....   (Y,N)                  Logged ............   (Y,N)      
   Lockmax ..........                                                           
   Lockpart .........   (Y,N)                                                   
   Maxrows ..........                                                           
   CCSID ...........* E                                                         
 Abstract     Zoom: N                                                           
                                                                                
                                                                                
   Additional attributes ..* N          Associations ..* N                      
Parameters
Tablespace name Name of the table space in DB2.
Type
Table space type.
S Segmented.
P Partitioned.
R Range partitioned.
G Partition by growth.
' ' Simple. This is the default setting.
Nr of partitions

Number of partitions used by the table space (corresponding to the NUMPARTS parameter, max. 4096) for table space type P or R. If 0 is specified, the table space is not partitioned.

Maximum number of partitions used by the table space (corresponding to the MAXPARTITIONS parameter, max. 4096) for table space type G.

Partitions can be defined

Partitions can be defined explicitly or with default values (see Using/free clause below) if table space type is either P or R. Partition definitions are used when generating table spaces from Predict dataspace objects.

Large
Identifies a table space as large.
Y Yes.
N No.
Buffer pool Name of the buffer pool to be associated with the table space. Enter asterisk for list of valid values.
Partition size Only valid for partitioned tablespaces. Enter asterisk (*) for valid values.
Locksize
Locking level for the table space. Valid values:
A any level locking
P page level locking
R row level locking
S table space level locking.
T table level locking (only valid for segmented DS)
Pages per segment

How many pages are to be assigned to each segment (parameter SEGSIZE) for table space type S, G or R.

Pages per segment must be zero for table space type ' ' (Simple) or P.

Logged
blank Not specified. This is the default setting.
Y Yes.
N No.
Close option
Y The data sets which support the table space are closed when nobody is using the table space.
Lockmax
The maximum number of pages or row locks an application can hold simultaneously in the table space. Valid values:
blank  
SYSTEM  
0 - 2,147,483,647.  
If parameter Locksize is set to S or T, Lockmax must be set to 0.
Lockpart
Partition locking. Valid values:
blank not specified
Y Yes
N No
Maxrows The maximum number of rows.
CCSID
Encoding scheme. Valid values:
blank not specified
A ASCII
E EBCDIC
Member cluster
Specifies that data inserted by the INSERT statement is not clustered by the implicit clustering index (the first index) or the explicit clustering index. Instead, DB2 chooses where to locate the data in the table space based on available space. Valid values:
blank not specified
Y Yes
N No
Additional attributes
Y

The partitions of the table space are to be defined. The following two options are available:

  • A default definition can be specified (the Using/free clause). The default values are used for partitions that are not defined explicitly.

  • Individual partitions can be defined. The screens to define individual partitions follow the screen for the definition of the default values.

Definition of Using/Free Clause

The values specified in the Definition of using/free clause section are used as default values.

Partitions can be defined explicitly in subsequent screens. See below.

16:32:28                 *****  P R E D I C T  *****                 2015-05-05
                             - Modify Dataspace -                              
Dataspace ID .... XYZ-PCTUPDP                         
Server Name ..... <Default Server>                                       
                                                                               
Definition of using/free clause                                                
     VSAM catalog name .......                                                 
  or Storagespace ...........*                                                 
                                                                               
     Primary attributes                                                        
       Free pages ............                                                 
       Percentage free ....... 11                                              
              for update ..... -1                                              
       Compress option .......   (Y,N)                                         
       GBPCACHE .............*                                                 
       TRACKMOD ..............   (Y,N)                                         
                                                                               
     Additional for storagespace                                               
       Primary allocation ....                                                 
       Secondary allocation ..                                                 
       Erase option ..........   (Y,N)                                         
                                                                               
* Additional attributes ..* y          Associations ..* N                      
Parameters
VSAM catalog name Name of the VSAM catalog containing an entry for the data sets of the table space. Must not be specified if the parameter Storagespace is specified.
Storagespace Name of the storagespace for the table space documented with the Predict Dataspace object. Must not be specified if the parameter VSAM catalog is specified.
Primary attributes
Free pages How often pages are to be left free when loading or reorganizing table spaces or partitions. Max. value is 255. Default is 0, leaving no free pages.
Percentage free Percentage of each page to be left free. Equivalent in DB2 is the PCTFREE option.
for update

Percentage of each page that is reserved to be used only by future update operations. Equivalent in DB2 is the PCTFREE FOR UPDATE option.

When you specify -1, DB2 uses real-time statistics to automatically calculate how much free space to reserve for updates. This is the default.

Compress option Specifies whether data compression applies to the rows of the tablespace.
GBPCACHE
Only relevant in a data sharing environment. Specifies what pages of the table space or partition are written to the group buffer pool. Leave this field blank or enter:
C Changed. Only pages that have been changed are written to the group buffer pool.
A All pages are written.
N No pages are written to the group buffer pool.
TRACKMOD
Specifies whether DB2 tracks changed pages in the space map pages.
Y Changed pages are tracked in the space map pages.
N Changed pages are not tracked.
Additional for storagespace
Primary allocation Primary space allocation for DB2 defined data sets.
Secondary allocation Secondary space allocation for DB2 defined data sets.
Erase option
Determines if DB2 defined data sets are to be erased when the table space is dropped:
N Do not erase data sets (default).
Y Erase data sets.

Defining Partitions

Each individual partition can be defined in the Definition of partitioned dataspace section. The maximum number of partitions is 4096.

Two partitions can be defined in one screen. To modify a specific partition, skip previous definitions by pressing ENTER.

14:58:46                 *****  P R E D I C T  *****                 2015-07-03
                             - Modify Dataspace -                              
Dataspace ID ... XYZ-DC                            Modified 2015-07-03 at 14:58
Server Name .... <Default Server>                        by XYZ                
--------------------- Definition of partitioned dataspace ---------------------
Partition                                                                      
1    VSAM catalog .          or Storagespace *                                 
     Primary attributes                    Additional for storagespace         
       Free pages ..........                 Primary allocation ...            
       Percentage free .....                 Secondary allocation .            
              for update ...                 Erase option .........   (Y,N)    
       Compress option .....   (Y,N)                                           
       GBPCACHE ...........*                                                   
       TRACKMOD ............   (Y,N)                                           
2    VSAM catalog .          or Storagespace *                                 
     Primary attributes                    Additional for storagespace         
       Free pages ..........                 Primary allocation ...            
       Percentage free .....                 Secondary allocation .            
              for update ...                 Erase option .........   (Y,N)    
       Compress option .....   (Y,N)                                           
       GBPCACHE ...........*                                                   
       TRACKMOD ............   (Y,N)                                           
* Additional attributes ..* S          Associations ..* N    Scroll to .. 1    
Parameters
See previous table above for a description of the parameters.

Defining Basic Attributes of Dataspace - SQL/DS

The following screen applies to SQL/DS dataspaces (type S).

   13:37:47             *****  P R E D I C T  *****             2007-05-31
                               - Add a Dataspace -
    Dataspace ID .... HNO-SQ
    Type ............ SQL-DS
    Keys ..                                                               Zoom: N
   
    Dataspace attributes
      Tablespace name .........
    Physical attributes in <Default Server>                 (new)
      Private dataspace .......   (Y/N)
      Size for header .........
      Size for dataspace ......
      Percentage for indices ..
      Percentage free .........
      Lock size ..............*
      Storage pool number .....
   
    Abstract     Zoom: N
  
Parameters
Tablespace name Identifier of the table space and name of the DBspace in SQL/DS.
Private dataspace
Y SQL/DS DBspace is private.
N Dataspace is public.
Size for header Number of 4096-byte logical pages reserved for header.
Size for dataspace Size reserved for the dataspace.
Percentage for indices Percentage of the reserved space that can be used for indexes.
Percentage free Percentage of reserved space to be kept free.
Locksize
Locking level for the dataspace. Valid values:
A Any level locking
P page
S dbspace
R row
T table
Storage pool number Storage pool number. This parameter tells SQL/DS to acquire the dbspace from a specified storage pool.

Defining Basic Attributes of Dataspace - DB2 Open Systems

The following screen applies to DB2 open systems dataspaces (type 2).

   13:37:47             *****  P R E D I C T  *****             2007-05-31
                               - Add a Dataspace -
    Dataspace ID .... HNO_TEST                                                     
    Type ............ DB2 open systems                                             

    Keys ..                                                               Zoom: N

    Dataspace attributes                                                          
     Tablespace name ..                                                           
    Physical attributes in <Default Server>                 (new)                
     Storagespace ....*                                                
     Data type .......*                          Transfer rate .... 0.90          
     Page size .......*                          Dropped table .... N (Y,N)       
     Space type ......*                                                           
     Extent size ......                                                           
     Prefetch size ....                                                          
     Buffer pool ......                                                     
     Overhead .........                                                      
    Abstract     Zoom: N                                                           
                                                                               
                                                                               
                                                                               
     Additional attributes ..* N          Associations ..* N                      
Parameters
Tablespace name Name of the tablespace in DB2.
Storagespace Name of the storagespace for the tablespace documented with the Predict dataspace object.
Data type
Valid data types:
R Regular
L Large
U User temporary
S System temporary
blank not specified
Page size Defines the size of pages used for the tablespace. Valid values: 4K, 8K, 16K, 32K, 4096, 8192, 16384, 32768 or not specified.
Space type
Specifies how the tablespace is to be managed:
S System managed
D Database managed
Extent size Specifies the number of PAGESIZE pages that will be written to a container before skipping to the next container. Valid values are 0 or integer or integer with unit K, M or G.
Prefetch size Specifies the number of PAGESIZE pages that will be written to a container before skipping to the next container. Valid values are 0 or integer or integer with unit K, M or G.
Buffer pool Name of the buffer pool to be associated with the tablespace.
Overhead Specifies the I/O controller overhead and disk seek and latency time (in milliseconds).
Transfer rate Specifies the time to read one page into memory (in milliseconds).
Dropped table
Specifies if dropped tables in the tablespace may be recovered. Valid values:
Y Yes
N No
blank Not specified

Definition of System Managed Containers

The following screen applies when defining system managed containers.

 15:25:25              *****  P R E D I C T  *****             2007-05-31
                              - Modify Dataspace -                              
 Dataspace ID ... HEB-DC-2                          Modified 2004-07-28 at 09:37
 Server Name .... <Default Server>                        by HEB                
                                                                                
 ------------------------ Definition of system containers ----------------------
                                                                                
 Container                                                                      
 1   Name ......... aaa                                                  Zoom N 
                                                                                
     Database partition number                                                  
       From ....... 0                                                           
       To ......... 0                                                           
                                                                                
 2   Name .........                                                      Zoom N 
                                                                                
     Database partition number                                                  
       From .......                                                             
       To .........                                                             
                                                                                
                                                                                
                                                                                
 * Additional attributes ..* S          Associations ..* N     Scroll to .. 1   
Parameters
Container Specifies the container for a tablespace.
Partition Specifies the partitions on which the containers are created in a partitioned database.

Definition of Database Managed Containers

The following screen applies when defining database managed containers.

 15:41:18              *****  P R E D I C T  *****             2007-05-31
                              - Modify Dataspace -                              
 Dataspace ID ... HEB-DC-2                          Modified 2004-07-28 at 09:37
 Server Name .... <Default Server>                        by HEB                
 ----------------------- Definition of database containers ---------------------
 Container                                                                      
 1   Name ......... aaa                                                  Zoom N 
     Type ........* D Device                                                    
     Pagesize .....                                                             
                                                                                
     Database partition number                                                  
      From ....... 0                                                           
      To ......... 0                                                           
                                                                                
 2   Name .........                                                      Zoom N 
     Type ........*                                                             
     Pagesize .....                                                             
                                                                                
      Database partition number                                                 
        From .......                                                            
        To .........                                                            
                                                                                
 * Additional attributes ..* S          Associations ..* N     Scroll to .. 1   
Parameters
Container Specifies the container for a tablespace.
Type
Specifies the type of the container. Valid values:
F File
D Device
Pagesize Specifies the container size.
Database partition number Specifies the partitions on which the containers are created in a partitioned database.