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 SPC
n option,
prim and
sec
are integers that specify
primary and secondary space, respectively, for the file
indicated by
n. The SPC
n 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
Abbreviations:
DATA BASE NAME = DBN
EXCLUSIVE = EXCL
-
After this command is executed, the QUEST processor is attached.
-
The database does not have to be defined or have values for you to issue
DATA BASE NAME IS.
-
You can open only one database at a time. To open a different database
that shares the current password, attach the CONTROL processor, then
issue DATA BASE NAME IS again to specify the other database.
To open another database with a different password, attach the CONTROL
processor, issue USER to specify the different password, then issue DATA
BASE NAME IS to specify the other database.
In both cases, the software closes the first database and opens the next
database, in that order.
-
You can dynamically allocate existing database files with the ALLOC
command in an SCF session. Or you can let SYSTEM 2000
search for the files automatically. If the JCL or CLIST contains
DD statements for the files, the software uses those allocations.
For more information about dynamic allocation of existing database
files, see the discussion of the ALLOC command in
SYSTEM 2000 CONTROL Language, Version 12, First Edition and
the discussions of database file allocation in the
SYSTEM 2000 Product Support Manual, Version 12, First Edition.
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
Abbreviation: LIST = LI
-
Only the master password holder can issue this command.
-
The output is written to the Message File.
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
Abbreviation: LIST = LI
-
Only the master password holder can issue this command.
-
The output shows only the commands authorized with ENABLE DBA FOR.
-
The output is written to the Message File.
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
Abbreviation: PRINT = PR
-
Only the master password holder or the DBA password holder (with
authorization) can issue this command.
-
The output is written to the Message File.
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
Abbreviations and synonyms:
PERCENT = PCT
ROLLBACK = RB
SYNCHPOINTS = SYNCHPOINT, SPTS, or SPT
-
Only the master password holder or the DBA password holder (with
authorization) can issue this command.
-
You must have exclusive use of the database to issue RESET ROLLBACK AFTER.
-
The database is cleared and the Rollback Log is reset after either
x-percent or y-synchpoints are reached.
-
You can issue this command regardless of whether the Rollback Log is
enabled.
-
You cannot issue RESET ROLLBACK AFTER for a damaged database.
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
After RESTORE is executed, the QUEST processor is attached.
-
Only the master password holder or the DBA password holder (with
authorization) can issue this command.
-
If update logging was active when the database was saved, it remains
active, even if you do not specify it.
-
Issue SAVE and then RELEASE before issuing RESTORE.
-
Update logging cannot be activated if you are changing the database
name.
-
Changing a database name suspends update logging.
-
The Savefile is a QSAM file. The Keepfile is a BSAM file.
DDnames for the Savefiles and Keepfiles are similar to the
DDnames for database Files 1 through 6. They consist of the first
seven characters of the database name (with blanks replaced by Xs) plus
a suffix of S for a Savefile and K for a Keepfile. TAPES2K and KEEPFILE
DDnames are not valid with Version 12 and subsequent releases.
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
Only the master password holder or the DBA password holder (with
authorization) can issue this command.
-
If update logging was previously active but you omit the slash, update
logging is suspended.
-
If the Rollback Log is enabled, a SAVE command creates a user synchpoint
for Coordinated Recovery.
-
If update logging is active and there have been updates, issue KEEP
before issuing the SAVE command.
-
In a Multi-User environment, this command does not require exclusive use
of the database.
-
You can SAVE a damaged database, but the damaged condition exists in the
saved copy of the database.
-
The Savefile is a QSAM file. The Keepfile is a BSAM file.
DDnames for the Savefiles and Keepfiles are similar to the
DDnames for database Files 1 through 6. They consist of the first
seven characters of the database name (with blanks replaced by Xs) plus
a suffix of S for a Savefile and K for a Keepfile. TAPES2K and KEEPFILE
filerefs are not valid with Version 12 and subsequent releases.
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