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 XYZ
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 XYZ ,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
|
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 .... XYZ-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).
15:56:34 ***** P R E D I C T ***** 2020-05-25
- Add a Dataspace -
Dataspace ID .... XYZ-DC
Type ............ DB2 mainframe
Located in DA ... DB2-V12A
Keys .. Zoom: N
Dataspace attributes
Tablespace name ..
Physical attributes in <Default Server> (new)
Type ............* Simple Member cluster .... (Y,N)
Nr of partitions . Large ............. N (Y,N)
Buffer pool .....* Partition size ...*
Locksize ........* (none) Pages per segment .
Close option ..... (Y,N) Logged ............ (Y,N)
Lockmax .......... Pagenum ..........* (none)
Lockpart ......... (Y,N) Insert algorithm .* (none)
Maxrows ..........
CCSID ...........* (none)
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. |
Pagenum |
Specifies the type of page
numbering that is used when you alter a partition-by-range table space.
|
' ' |
None. This is the default
setting.
|
R |
Relative. |
A |
Absolute. |
Insert algorithm |
Specifies the algorithm
that is used when rows are inserted into tables in this table space.
|
' ' |
None. This is the default
setting.
|
1 |
Level 1. |
2 |
Level 2. |
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. |
U |
Unicode. |
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 ***** 2021-01-03
- Modify Dataspace -
Dataspace ID ... XYZ-DC Modified 2021-01-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 ...........* DSSIZE (G) ..........
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 ...........* DSSIZE (G) ..........
TRACKMOD ............ (Y,N)
Additional attributes ..* S Associations ..* N Scroll to .. 1 |
Parameters |
DSSIZE |
Specifies the maximum size (in Gbyte)
for each partition of a partitioned index.
|
For all other
values/options 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.
|