Resources

Home   News   Version 1   Tech Support   Pubs   S2K Site Map




SYSTEM 2000 Quick Reference Guide CONTROL Language Commands



ALLOC

Allocates new or existing database files dynamically within an SCF session if they are not allocated in the JCL or CLIST.

Syntax

ALLOC database [,DSN=dsn], DISP=NEW  [,options] :

ALLOC database [,DSN=dsn], DISP=|OLD :
                              |SHR
database
is the name of a new database to be created or an existing database. It can have 1 to 16 characters.
dsn
is a data set name of up to 44 characters. Use quotes for a fully qualified name. If you do not specify the data set name, the default is the prefix followed by the first seven characters of the database name (with embedded blanks replaced by Xs) and a suffix of S for the Savefile and K for the Keepfile.

DISP
specifies the disposition of NEW for new database files. For existing database files, the disposition is OLD or SHR. DISP=SHR in a single-user job causes read-only access to the database. OLD is the default.

options
is a list of one or more parameters separated by commas. You can use these options to change the default attributes for all new files or specific new files. They are ignored for existing database files. The options are shown below; n is an integer 1 through 8, representing one of the database files.
OPTION   DESCRIPTION                          DEFAULT

BLK=     any valid SYSTEM 2000 block size     6216
BLKn=    any valid SYSTEM 2000 block size     the BLK value


UNIT=    any valid unit for your site         SYSDA
UNTn=    any valid unit for your site         the UNIT value

VOL=     any valid volser                     scratch volume
VOLn=    any valid volser                     the VOL value

FILES=   ALL                                  Files 1 through 8
FILES=   1, 2, 3, 4, 5, 6, 7, or 8            that file only
         FILES option not specified           Files 1 through 6 only

SPACE=   SMALL or LARGE                       SMALL
SPCn=    (TRK or CYL,prim,sec)                  the SPACE values
The SPACE option determines the database file sizes for Files 1 through 8. For the SPCn option, prim and sec are integers that specify primary and secondary space, respectively, for the file indicated by n. The SPCn option overrides the SPACE value.

Here are the default values for the new database file SPACE options:

DATABASE FILES              SMALL         LARGE

Files 1, 3, and 4           (TRK,(3,5))   (TRK,(30,50))

Files 2, 5, 6, 7, and 8     (CYL,(1,5))   (CYL,(10,50))

Examples

ALLOC PERSONNEL, DISP=NEW:

ALLOC EMPLOYEE:

ALLOC FINANCE,FILES=ALL,VOL=SAS834,DISP=NEW:

ALLOC CARS,SPACE=LARGE,DISP=NEW:

ALLOC SALES,BLK5=23464,BLK6=23464,DISP=NEW:

Rules

Back to Top of Page


APPLY

Applies recorded updates from the Keepfile to a restored database.

Syntax

APPLY  |ALL             :
       |THROUGH CYCLE n
n
is the last update cycle number to be applied to a saved database. The number must be greater than 0.

Examples

APPLY ALL:

APPLY THRU CYCLE 55:

Rules

Back to Top of Page


ASSIGN AUTHORITIES

Assigns, changes, or removes authorities for secondary passwords.

Syntax

ASSIGN |authorities TO |component [, component]... FOR |ALL PASSWORDS :
       |N           |ALL COMPONENTS               |passwords

ASSIGN |authorities TO component THROUGH component FOR |ALL PASSWORDS :
       |N                                         |passwords
authorities
can be any of the following: R, U, and W in any combination, separated by commas; or N used alone.

R-authority allows retrieval of specific components.

U-authority allows updating of specific items or records.

W-authority allows specific items or records in where-clauses.

N-authority restricts knowledge of specific components and removes previously assigned authorities.

component
is a component name or component number.

passwords
is a list of one or more secondary passwords, separated by commas.

Examples

AS R TO C101 FOR ABLE:

ASSIGN W,U TO C7,C8,C202 FOR ALL PASSWORDS:

ASSIGN R TO C201 THRU C203 FOR BAKE:

AS R,W,U TO ALL COMPONENTS FOR +:

ASSIGN N TO GENDER, ETHNIC ORIGIN FOR +,CHAR:

Rules

Back to Top of Page


CHANGE PASSWORD

Changes the master password, the secondary passwords, and the DBA password.

Syntax

CHANGE PASSWORD old-password TO new-password :
old-password
is an existing password.

new-password
is a new password using 1 to 4 alphanumeric characters with no blanks. The password can also be a single special character or lowercase letter. See Special Characters in Appendices .

Examples

CHANGE PASSWORD ABLE TO BAK:

CH PASSWORD + TO $:

Rules

Back to Top of Page


CREATE INDEX

Changes items from non-key to key and creates an index for each.

Syntax

[CREATE] INDEX items :
items
is a list of one or more non-key item names or component numbers, separated by commas. The maximum is 96 items.

Examples

CREATE INDEX C3:

INDEX C106, PROFICIENCY, MAJOR FIELD:

Rules

Back to Top of Page


DATA BASE NAME IS

Opens an active database.

Syntax

[EXCLUSIVE] DATA BASE NAME IS database :
EXCLUSIVE
specifies exclusive use of the database; no other user can open the database until you close it.

database
is a name previously assigned to a database. It can have 1 to 16 characters.

Examples

DATA BASE NAME IS EMPLOYEE:

EXCL DBN IS STATUS:

DBN IS SALES:

Rules

Back to Top of Page


DBA PASSWORD IS

Assigns the DBA password so that the database administrator can perform administrative functions.

Syntax

DBA PASSWORD IS password :
password
is a word of 1 to 4 alphanumeric characters with no blanks. The password can also be a single special character or lowercase letter. See Special Characters in Appendices .

Examples

DBA PASSWORD IS FOX:

DBA PASSWORD IS ?:

DBA PASSWORD IS A5:

Rules

Back to Top of Page


ENABLE/DISABLE DBA FOR

Controls the DBA password authorization of commands chosen from a list of available commands.

Syntax

|ENABLE DBA FOR |ALL COMMANDS :
|DISABLE        |command
command
is any of the following:
APPLY            RESET ROLLBACK
FULL PASSES      RESTORE
MULTIPLE HOLDS   ROLLBACK
PRINT SIZE       SAVE
RELEASE          SUSPEND
RELOAD           VALUES PADDING
REORGANIZE

Examples

ENABLE DBA FOR ALL COMMANDS:

DISABLE DBA FOR RELEASE:

ENABLE DBA FOR PRINT SIZE, RELOAD, REORGANIZE:

Rules

Back to Top of Page


ENABLE/DISABLE MULTIPLE HOLDS

Allows PLEX users to acquire multiple local holds simultaneously on a database in a Multi-User environment, or prohibits the same.

Syntax

|ENABLE MULTIPLE HOLDS :
|DISABLE

Examples

ENABLE MULTIPLE HOLDS:

DISABLE MULTIPLE HOLDS:

Rules

Back to Top of Page


ENABLE/DISABLE ROLLBACK

Controls the Rollback Log to allow or prevent recovery of a database.

Syntax

|ENABLE ROLLBACK :
|DISABLE

Examples

ENABLE ROLLBACK:

DISABLE ROLLBACK:

Rules

Back to Top of Page


ENABLE/DISABLE ROUTINE

Enables or disables user exits.

Syntax

|ENABLE ROUTINE names FOR EXITS range [, range] ... :
|DISABLE
names
is a list of 1 to 10 routine names, separated by commas. Each name is 1 to 8 characters and is designated by the installation systems programmer responsible for coding user exits.

range
nn [THROUGH mm]

nn
is an integer from 00 to 63, depending on how EXIT01 is coded. (You can enter a single-digit integer with or without the leading 0, that is, 3 or 03.)

mm
is a positive integer greater than nn and less than or equal to 63, depending on how EXIT01 is coded. (You can enter a single-digit integer with or without the leading 0.)

Examples

ENABLE ROUTINE A3, C4, Z8 FOR EXITS 09 THRU 12:

DISABLE ROUTINE ALL FOR EXITS 17 THRU 20:

ENABLE ROUTINE FIVE FOR EXIT 5:

Rules

Back to Top of Page


ENTRY KEY IS

Invokes or cancels the Security by Entry feature, which restricts the access of secondary password holders to specific logical entries, based on a unique value for the specified entry key.

Syntax

ENTRY KEY IS item :

ENTRY KEY IS |ENTRY                :
             |C0
             |user-defined-C0-name
item
is a level 0 key item name or component number designated as the entry key.

ENTRY
cancels Security by Entry.

C0
cancels Security by Entry.

user-defined-C0-name
is an ENTRY record that has been renamed. Cancels Security by Entry.

Examples

ENTRY KEY IS C1:

ENTRY KEY IS ENTRY:

ENTRY KEY IS C0:

Rules

Back to Top of Page


FREE

Closes the specified database and deallocates Files 1 through 8.

Syntax

FREE database :
database
is the name of the database to be deallocated. It must be a valid database name of 1 to 16 characters.

Example

FREE EMPLOYEE:

Rules

Back to Top of Page


FULL PASSES

Allows or prohibits complete passes through the database Data Table.

Syntax

|[ALLOW] FULL PASSES :
|[NO]

Examples

NO FULL PASSES:

FULL PASSES:

Rules

Back to Top of Page


INVALID PASSWORD IS

Deletes a secondary password or the DBA password.

Syntax

INVALID PASSWORD IS password :
password
is a valid secondary or DBA password that you want to delete.

Examples

INVALID PASSWORD IS ABLE:

INVALID PASSWORD IS +:

INVALID PASSWORD IS X9:

Rules

Back to Top of Page


KEEP

Requests the transfer of updates from the Update Log to the Keepfile.

Syntax

KEEP :

Example

KEEP:

Rules

Back to Top of Page


LIST DBA

Displays the DBA password.

Syntax

LIST DBA :

Example

LI DBA:

Rules

Back to Top of Page


LIST DBA AND COMMANDS

Displays the DBA password and commands that are authorized for the DBA password.

Syntax

LIST DBA AND COMMANDS :

Example

LI DBA AND COMMANDS:

Rules

Back to Top of Page


LIST PASSWORDS

Displays the secondary passwords.

Syntax

LIST PASSWORDS :

Example

LI PASSWORDS:

Rules

Back to Top of Page


LIST PASSWORDS AND AUTHORITIES

Displays the secondary passwords and their authorities by component.

Syntax

LIST PASSWORDS AND AUTHORITIES :

Example

LI PASSWORD AND AUTH:

Rules

Back to Top of Page


NEW DATA BASE IS

Assigns a name to a new database.

Syntax

NEW DATA BASE IS database [/n] :
database
is a name to be assigned to a database. The database name can have 1 to 16 characters. The first seven characters are used for the DDname, which must be unique within either the MVS or CMS environment.

n
is an optional number from 1 to 10,000 specifying the maximum number of components (including the C0 component, strings, and functions) that can be defined. The default is 430.

Examples

NEW DATA BASE IS EMPLOYEE:

NDB IS EMPLOYEE/800:

NDB IS FREIGHT-CAR:

Rules

Back to Top of Page


PRINT SIZE

Displays database size statistics.

Syntax

PRINT SIZE :

Example

PR SIZE:

Rules

Back to Top of Page


RELEASE

Renders the active database disk files unusable until the database is restored.

Syntax

RELEASE :

Example

RELEASE:

Rules

Back to Top of Page


RELOAD

Reconstructs the database files by unloading the database internally and then rebuilding the database tables.

Syntax

RELOAD [[ordering-clause] where-clause] :
ordering-clause
specifies the order of selected data records. Use only level 0 items. A where-clause is required if an ordering-clause is specified. See Ordering-Clause in QUEST .

where-clause
selects specific data records. The SAME operator cannot be included. See Where-Clause in QUEST .

Examples

RELOAD:

RELOAD WHERE EMPLOYEE NUMBER LT 5075:

RELOAD ORDERED BY C1 WHERE C1 EXISTS:

Rules

Back to Top of Page


REMOVE INDEX

Changes items from key to non-key and removes the index for each.

Syntax

REMOVE INDEX |[/LOSE/] items :
             |[/REUSE/]
LOSE
specifies that removed Multiple Occurrence Table space is lost until restructuring, reorganizing, or reloading occurs. LOSE is the default.

REUSE
specifies that removed Multiple Occurrence Table space is placed on the reusable space lists.

items
is a list of one or more key item names or component numbers, separated by commas. The maximum is 96 items.

Examples

REMOVE INDEX C413:

RE INDEX /REUSE/ C423, POSITION TYPE:

Rules

Back to Top of Page


REORGANIZE

Compacts and reorders the index. Use this command when database entries become scattered due to incremental loads or many updates.

Syntax

REORGANIZE |DVT   :
           |MOT
           |ALL
           |INDEX

Examples

REORGANIZE DVT:

REORGANIZE ALL:

Rules

Back to Top of Page


RESET ROLLBACK AFTER

Controls the number of pages that are written to the Rollback Log and the extent of recovery that occurs in the event of a transaction or system failure.

Syntax

RESET ROLLBACK AFTER |x PERCENT                :
                     |y SYNCHPOINTS
                     |x PERCENT, y SYNCHPOINTS
x
is the percentage of primary space that can be written to the Rollback Log before it is reset. Zero percent clears the database and resets the log at the start of each synchpoint. One hundred percent resets the log after primary allocation is used. The default is 50.

y
is the number of user synchpoints that can occur between clearing the database and resetting the Rollback Log. y can be any number from 1 to 999999. The default is 999999.

Examples

RESET ROLLBACK AFTER 80 PCT, 20000 SYNCHPOINTS:

RESET ROLLBACK AFTER 75 PERCENT:

RESET RB AFTER 15000 SPTS:

Rules

Back to Top of Page


RESTORE

Copies a database from a Savefile onto the active database files. This command can also activate update logging and change the name of a database.

Syntax

RESTORE old-database [=new-database] [FROM Savefile-identifier]
   [/] [Keepfile-identifier] :
old-database
is the name of an existing database.

new-database
is the new database name using 1 to 16 characters. The first seven characters are used for the DDname, which must be unique within the MVS or CMS environment.

Savefile-identifier
[volume-list] [UNIT=unit]
[DSN=data-set-name] [DS=sequence-number]
If specified, volume-list must be the first parameter. UNIT, DSN, and DS can be specified in any order.

volume-list
volume [volume-list]
You can specify up to 10 volumes for the Savefile.

volume
is a standard volume identification label of up to six characters. If you do not specify a volume and you specify UNIT=TAPE, the default is a scratch tape.

unit
is a device unit of 1 to 8 characters, such as TAPE, RIO, VIO. The default is disk (SYSDA).

data-set-name
is a data set name of up to 44 characters. Use quotes for a fully qualified name. If you do not specify the data set name, the default is the prefix followed by the first seven characters of the database name (with embedded blanks replaced by Xs) and a suffix of S for the Savefile and K for the Keepfile.

sequence-number
is a data set sequence number for the Savefile or Keepfile. The number can be 1 to 255. This number applies only to the first volume of a multi-volume data set. Recording continues at the beginning of additional volumes (DS=1). The default is 1.

/
activates update logging.

Keepfile-identifier
[volume] [UNIT=unit]
[DSN=data-set-name] [DS=sequence-number]
Only one volume can be specified for the Keepfile. If specified, volume must be the first parameter. UNIT, DSN, and DS can be specified in any order.

Examples

RESTORE EMPLOYEE:

RESTORE BOOKS FROM SAS290:

RESTORE BOOKS FROM DSN=BOOKSAVE:

RESTORE LIBRARY = STACKS:

RESTORE CARS /:

Rules

Back to Top of Page


SAVE

Copies a database to save it. This command can also activate or suspend update logging.

Syntax

SAVE [DATA BASE] [ON Savefile-identifier] [/] [Keepfile-identifier] :
Savefile-identifier
[volume-list] [UNIT=unit]
[DSN=data-set-name] [DS=sequence-number]
If specified, volume-list must be the first parameter. UNIT, DSN, and DS can be specified in any order.

volume-list
volume [,volume-list]
You can specify up to 10 volumes for the Savefile.

volume
is a standard volume identification label of up to six characters. If you do not specify a volume and you specify UNIT=TAPE, the default is a scratch tape.

unit
is a device unit of 1 to 8 characters, such as TAPE, RIO, VIO. The default is disk (SYSDA).

data-set-name
is a data set name of up to 44 characters. Use quotes for a fully qualified name. If you do not specify the data set name, the default is the prefix followed by the first seven characters of the database name (with embedded blanks replaced by Xs) and a suffix of S for the Savefile and K for the Keepfile.

sequence-number
is a data set sequence number for the Savefile or Keepfile. The number can be 1 to 255. This number applies only to the first volume of a multi-volume data set. Recording continues at the beginning of additional volumes (DS=1). The default is 1.

/
activates update logging.

Keepfile-identifier
[volume] [UNIT=unit]
[DSN=data-set-name] [DS=sequence-number]
Only one volume can be specified for the Keepfile. If specified, volume must be the first parameter. UNIT, DSN, and DS can be specified in any order.

Examples

SAVE:
(Update logging is not specified.)
SAVE /:
(Update logging is activated.)
SAVE DATA BASE ON ML001/ML002:

Rules

Back to Top of Page


SUSPEND

Stops the recording of database updates.

Syntax

SUSPEND :

Example

SUSPEND:

Rules

Back to Top of Page


USER

Accesses SYSTEM 2000 and gives the password for the database to be opened, either setting the master password for a new database or verifying the password for an existing database.

Syntax

USER, password :
password
is a word of 1 to 4 alphanumeric characters with no blanks. The password can also be a single special character or lowercase letter. See Special Characters in Appendices .

Examples

USER, DEMO:  DATA BASE NAME IS EMPLOYEE:

USER, +:  NEW DATA BASE NAME IS OIL SPILLS:

Rules

Back to Top of Page


VALID PASSWORD IS

Assigns secondary passwords for a database.

Syntax

VALID PASSWORD IS password :
password
is a word of 1 to 4 alphanumeric characters with no blanks. The password can also be a single special character or lowercase letter. See Special Characters in Appendices .

Examples

VALID PASSWORD IS ABLE:

VALID PASSWORD IS +:

VALID PASSWORD IS X9:

Rules

Back to Top of Page