DBMAINT Mode - DATACOM/DB Structure Maintenance › Partitioning a Table

Partitioning a Table

In DBMAINT Mode, use the PARTITION TABLE function when you want to define a table as partitioned and establish the table partitions for that table.

You can use the PARTITION function with TABLE occurrences only.

 =>
 =>
 =>
 1-DDOL000196A - CMPP - PLEASE COMPLETE REQUIRED INFORMATION FOR COMMAND
 -------------------------------------------------------------------------------
 DATACOM/DB Structure Maintenance
                                                                            TXCF
 PARTITION TABLE    ________________________________ in STATUS ____
 PTN       TBL      (name)                              STAT  (stat)

 with PASSWORD ____ using OVERRIDE ____
      PSWD    (pswd)      OVRD    (ovrd)










 PF1=HELP  PF2=END  PF3=CLARIFY  PF4=PROCESS  PF5=MENU   PF6=STATUS
 PF7=SCB   PF8=SCF  PF9=APPLY    PF10=PATH    PF11=NEXT  PF12=INPUT

The following list describes each field, the valid entries and the default (if one exists). Fields that require an entry are highlighted on your terminal. Fields which are not highlighted indicate that an entry is optional.

(name)

(Required) Specify the name of the TABLE occurrence you are partitioning.

Valid Entries:

1- to 32-character occurrence name

Default Value:

(No default)

(stat)

(Required) Specify the status of the TABLE occurrence you are partitioning.

Valid Entries:

TEST
T001—T999
PROD 001—999
QUAL
ALL

Default Value:

(No default)

(pswd)

Only required if this occurrence has protection against unauthorized maintenance with a password assignment. Supply the password for this occurrence.

Valid Entries:

1- to 4-character password

Default Value:

(No default)

(ovrd)

Only required if this occurrence is restricted from unauthorized maintenance or retrieval with a lock level assignment. Supply the override code.

Valid Entries:

1- to 4-character override code

Default Value:

(No default)

When you press Enter, the PARTITION panel appropriate for the specified TABLE occurrence, either a partitioned table (see Partitioned Table) or Table Partition.