DB2/LUW Commands  Übersicht  Siehe IBM DB2 LUW CMD.Doc

 

ACTIVATE DATABASE

ACTIVATE DATABASE ALIASNAME-DER-DATENBANK [USER BENUTZERNAME [USING KENNWORT]]

ADD CONTACT

ADD CONTACT NAME-DES-ANSPRECHPARTNERS TYPE {EMAIL | PAGE [MAXIMUM PAGE LENGTH SEITENLäNGE]}
ADDRESS EMPFäNGERADRESSE [DESCRIPTION BESCHREIBUNG-DES-ANSPRECHPARTNERS]

ADD CONTACTGROUP

ADD CONTACTGROUP NAME-DER-ANSPRECHPARTNERGRUPPE {CONTACT | GROUP} NAME
[ {,{CONTACT | GROUP} NAME} ... ] [DESCRIPTION BESCHREIBUNG-DER-ANSPRECHPARTNERGRUPPE

ADD DBPARTITIONNUM

ADD DBPARTITIONNUM
[LIKE DBPARTITIONNUM DATENBANKPARTITIONSNUMMER | WITHOUT TABLESPACES]

ADD XMLSCHEMA

ADD XMLSCHEMA DOCUMENT TO RELATIONALE-KENNUNG
ADD DOKUMENT-URI FROM INHALTS-URI [WITH EIGENSCHAFTEN-URI] ...
[COMPLETE [WITH SCHEMAEIGENSCHAFTEN-URI][ENABLE DECOMPOSITION]]

ARCHIVE LOG

ARCHIVE LOG FOR DATABASE ALIASNAME-DER-DATENBANK [USER BENUTZER [USING KENNWORT]]
[ON-DBPARTITIONNUM-KLAUSEL]

ON-DBPARTITIONNUM-KLAUSEL:
ON {{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ... ) | ALL DBPARTITIONNUMS [EXCEPT
{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ...)]}

ATTACH

ATTACH [TO KNOTENNAME]
[USER BENUTZER [{USING KENNWORT
[NEW NEUES-KENNWORT CONFIRM KENNWORTBESTäTIGUNG] |
CHANGE PASSWORD}]]

AUTOCONFIGURE

AUTOCONFIGURE [USING KONFIGURATIONSSCHLüSSEL [{KONFIGURATIONSSCHLüSSEL}...]]
[APPLY {DB ONLY | DB ONLY ON CURRENT MEMBER | DB AND DBM
| DB AND DBM ON CURRENT MEMBER | NONE}]

KONFIGURATIONSSCHLüSSEL:
MEM_PERCENT, WORKLOAD_TYPE, NUM_STMTS, TPM, ADMIN_PRIORITY, IS_POPULATED
NUM_LOCAL_APPS, NUM_REMOTE_APPS, ISOLATION, BP_RESIZEABLE.

BACKUP DATABASE

BACKUP DATABASE ALIASNAME-DER-DATENBANK [USER BENUTZER [USING KENNWORT]]
[ON-DBPARTITIONNUM-KLAUSEL]
[TABLESPACE (TABBEREICHSNAME [{, TABBEREICHSNAME} ... ])]
[ONLINE] [INCREMENTAL [DELTA]]
[DATENTRäGERZIELKLAUSEL] [DEDUP_DEVICE]
[WITH ANZAHL-DER-PUFFER BUFFERS] [BUFFER PUFFERGRößE] [PARALLELISM N]
[COMPRESS [COMPRLIB BIBLIOTHEKSNAME [EXCLUDE]] [COMPROPTS OPTIONSZEICHENFOLGE]]
[UTIL_IMPACT_PRIORITY [PRIORITäT]] [{INCLUDE | EXCLUDE} LOGS]
[WITHOUT PROMPTING]

ON-DBPARTITIONNUM-KLAUSEL:
ON {{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ... ) | ALL DBPARTITIONNUMS [EXCEPT
{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ...)]}

DATENTRäGERZIELKLAUSEL:
USE {TSM | XBSA}
[OPEN ANZAHL-SITZUNGEN SESSIONS] | SNAPSHOT [ {LIBRARY | SCRIPT} DATEINAME] ]
[OPTIONS {OPTIONSZEICHENFOLGE | NAME-DER-OPTIONSDATEI}] |
LOAD BIBNAME [OPEN ANZAHL-SITZUNGEN SESSIONS]
[OPTIONS {OPTIONSZEICHENFOLGE | NAME-DER-OPTIONSDATEI}] |

BIND

BIND {DATEINAME | @DATEILISTE} [ACTION {ADD | REPLACE [RETAIN {YES | NO}]
[REPLVER VERSIONS-ID]}] [APREUSE {YES | NO}] [BLOCKING {UNAMBIG | ALL | NO}]
[CLIPKG ANZAHL-PAKETE] [COLLECTION OBJEKTGRUPPEN-ID]
[CONCURRENTACCESSRESOLUTION {USE_CURRENTLY_COMMITTED | USE CURRENTLY COMMITTED
USECURRENTLYCOMMITTED | WAIT_FOR_OUTCOME | WAIT FOR OUTCOME | WAITFOROUTCOME}]
[DATETIME {DEF | USA | EUR | ISO | JIS | LOC}] [DEGREE {1 | GRAD_DER_PARALLELITäT
| ANY}] [DYNAMICRULES {RUN | BIND | INVOKERUN | INVOKEBIND | DEFINERUN | DEFINEBIND}]
[EXPLAIN {NO | YES | REOPT | ALL | ONLY} [EXPLSNAP {NO | YES | REOPT | ALL}]
[EXTENDEDINDICATOR {NO | YES}]
[FEDERATED {NO | YES}] [FUNCPATH SCHEMANAME [{,SCHEMANAME} ... ]]
[FEDERATED_ASYNCHRONY {ANY | ANZAHL-ATQS-IM-PLAN}] [GENERIC ZEICHENFOLGE]
[GRANT {BERECHTIGUNGS-ID | PUBLIC}] [GRANT_GROUP GRUPPENNAME] [GRANT_USER BENUTZERNAME]
[GRANT_ROLE ROLLENNAME] [INSERT {BUF | DEF}] [ISOLATION {CS | RR | UR | RS | NC}]
[MESSAGES NACHRICHTENDATEI] [OPTPROFILE OPTIMIERUNGSPROFIL]
[OWNER BERECHTIGUNGS-ID] [QUALIFIER QUALIFIKATIONSNAME]
[QUERYOPT OPTIMIERUNGSSTUFE] [REOPT {NONE | ONCE | ALWAYS}]
[SQLERROR {NOPACKAGE | CHECK | CONTINUE}] [VALIDATE {RUN | BIND}]
[SQLWARN {NO | YES}] [STATICREADONLY {NO | YES | INSENSITIVE}]
[STRING_UNITS {SYSTEM | CODEUNITS32}] [TRANSFORM GROUP UMSETZUNGSGRUPPE]
*******************************************************************************
* DIE FOLGENDEN OPTIONEN GELTEN NUR, WENN EINE VERBINDUNG ZU EINEM HOST ODER ISERIES-SERVER BESTEHT *
*******************************************************************************
[CCSIDG DBCS-CCSID] [CCSIDM MISCH-CCSID] [CCSIDS SBCS-CCSID]
[CHARSUB {DEFAULT | BIT | SBCS | MIXED}] [CNULREQD {YES | NO}]
[DBPROTOCOL {DRDA | PRIVATE}] [DEC {31 | 15}] [DECDEL {PERIOD | COMMA}]
[ENCODING {ASCII | EBCDIC | UNICODE | CCSID}]
[IMMEDWRITE {NO | YES | PH1}] [KEEPDYNAMIC {NO | YES}]
[OPTHINT HINWEIS-ID] [OS400NAMING {SQL | SYSTEM}] [PATH SCHEMANAME]
[RELEASE {COMMIT | DEALLOCATE}]
[SORTSEQ {HEX | JOBRUN}] [STRDEL {APOSTROPHE | QUOTE}] [TEXT BEZEICHNUNG]

CATALOG APPC NODE

CATALOG APPC NODE KNOTENNAME REMOTE SYMBOLISCHER-BESTIMMUNGSNAME
[SECURITY {NONE | SAME | PROGRAM}] [REMOTE_INSTANCE INSTANZNAME]
[SYSTEM SYSTEMNAME] [OSTYPE BETRIEBSSYSTEMTYP] [WITH "KOMMENTARZEICHENFOLGE"]

CATALOG APPN NODE

CATALOG APPN NODE NODE-NAME [NETWORK NETZ-ID] REMOTE PARTNER-LU
[LOCAL LOKALE-LU] [TPNAME TP-NAME] [MODE MODUS]
[SECURITY {NONE | SAME | PROGRAM}] [LANADDRESS LAN-ADAPTERADRESSE]
[CHGPWDLU KENNWORTäNDERUNGS-LU] [WITH "KOMMENTARZEICHENFOLGE"]

CATALOG DATABASE

CATALOG DATABASE DATENBANK [AS ALIAS] {ON LAUFWERK | AT NODE KNOTENNAME}
[AUTHENTICATION {SERVER | CLIENT | DCS | DCE SERVER PRINCIPAL HAUPTNAME
| KERBEROS TARGET PRINCIPAL NAME-DES-PRINCIPALS | SERVER_ENCRYPT | SERVER_ENCRYPT_AES
| DCS_ENCRYPT | DATA_ENCRYPT | GSSPLUGIN}] [WITH "KOMMENTARZEICHENFOLGE"]

CATALOG DCS DATABASE

CATALOG DCS DATABASE DATENBANKNAME [AS ZIELDATENBANKNAME]
[AR ANWENDUNGS-REQUESTERNAME] [PARMS "PARAMETERZEICHENFOLGE"] [WITH "KOMMENTARZEICHENFOLGE"]

CATALOG LDAP DATABASE

CATALOG LDAP DATABASE DATENBANKNAME [AS ALIAS]
[AT NODE KNOTENNAME] [GWNODE GATEWAYKNOTEN]
[AR ANWENDUNGS-REQUESTER-NAME] [PARMS "PARAMETERZEICHENFOLGE"]
[AUTHENTICATION {SERVER | CLIENT | DCS | DCE SERVER PRINCIPAL HAUPTNAME
| KERBEROS TARGET PRINCIPAL NAME-DES-PRINCIPALS | SERVER_ENCRYPT | SERVER_ENCRYPT_AES
| DCS_ENCRYPT | DATA_ENCRYPT | GSSPLUGIN}]
[WITH "KOMMENTARZEICHENFOLGE"] [USER BENUTZER [PASSWORD KENNWORT]]

CATALOG LDAP NODE

CATALOG LDAP NODE KNOTENNAME [AS ALIASNAME-DES-KNOTENS]
[USER BENUTZER [PASSWORD KENNWORT]]

CATALOG LOCAL NODE

CATALOG [ADMIN] LOCAL NODE KNOTENNAME
[INSTANCE INSTANZNAME] [SYSTEM SYSTEMNAME]
[OSTYPE BETRIEBSSYSTEMTYP] [WITH "KOMMENTARZEICHENFOLGE"]

CATALOG NPIPE NODE

CATALOG NPIPE NODE KNOTENNAME REMOTE COMPUTERNAME
INSTANCE INSTANZNAME [SYSTEM SYSTEMNAME]
[OSTYPE BETRIEBSSYSTEMTYP] [WITH "KOMMENTARZEICHENFOLGE"]

CATALOG ODBC DATA SOURCE

CATALOG [USER | SYSTEM] ODBC DATA SOURCE NAME-DER-DATENQUELLE
| ALL DATA SOURCES }

CATALOG TCPIP NODE

CATALOG [ADMIN] {TCPIP | TCPIP4 | TCPIP6} NODE KNOTENNAME REMOTE HOSTNAME
[SERVER SERVICENAME] [SECURITY {SOCKS | SSL}] [REMOTE_INSTANCE INSTANZNAME]
[SYSTEM SYSTEMNAME] [OSTYPE BETRIEBSSYSTEMTYP] [WITH "KOMMENTARZEICHENFOLGE"]

CHANGE DATABASE COMMENT

CHANGE DATABASE DATABASE COMMENT [ON LAUFWERK] WITH "KOMMENTARZEICHENFOLGE"

CHANGE ISOLATION LEVEL

CHANGE {SQLISL | ISOLATION} TO {CS | RR | UR | RS | NC}

COMPLETE XMLSCHEMA

COMPLETE XMLSCHEMA RELATIONALE-KENNUNG
[WITH SCHEMAEIGENSCHAFTEN-URI][ENABLE DECOMPOSITION]

CREATE DATABASE

CREATE DATABASE DATENBANKNAME
[AT DBPARTITIONNUM | [AUTOMATIC STORAGE {NO | YES}]
[ON LAUFWERK[{,LAUFWERK}...][DBPATH ON LAUFWERK]]
[ALIAS ALIASNAME-DER-DATENBANK] [USING CODESET CODIERTER-ZEICHENSATZ TERRITORY GEBIET]
[COLLATE USING {SYSTEM | IDENTITY | IDENTITY_16BIT | COMPATIBILITY | NLSCHAR | UCA400_NO | UCA400_LSK | UCA400_LTH | SPRACHSENSITIVE-SORTIERFOLGE | LOCALEABHäNGIGE-SORTIERFOLGE}]
[PAGESIZE GANZZAHL [K]]
[NUMSEGS ANZAHL-SEGMENTE] [DFT_EXTENT_SZ STANDARDSPEICHERBEREICHSGRößE] [RESTRICTIVE]
[CATALOG TABLESPACE TABBEREICHSDEF] [USER TABLESPACE TABBEREICHSDEF]
[TEMPORARY TABLESPACE TABBEREICHSDEF] [WITH "KOMMENTARZEICHENFOLGE"] ]
[AUTOCONFIGURE [USING KONFIGURATIONSSCHLüSSEL [{,KONFIGURATIONSSCHLüSSEL}...]]
[APPLY {DB ONLY | DB AND DBM | NONE}]]

SPRACHSENSITIVE-SORTIERFOLGE, LOCALEABHäNGIGE-SORTIERFOLGE:
EINE VOLLSTäNDIGE LISTE DER OPTIONEN FINDEN SIE IM THEMA "BEFEHL CREATE DATABASE" IM INFORMATION CENTER.

TABBEREICHSDEF:
MANAGED BY { SYSTEM USING ('ZEICHENFOLGE' [ {,'ZEICHENFOLGE'} ... ] ) |
DATABASE USING ({FILE | DEVICE} 'ZEICHENFOLGE' SEITENANZAHL
[ {,{FILE | DEVICE} 'ZEICHENFOLGE' SEITENANZAHL} ... ]) | AUTOMATIC STORAGE}
[EXTENTSIZE SEITENANZAHL] [PREFETCHSIZE SEITENANZAHL]
[OVERHEAD ANZAHL-MILLISEKUNDEN] [TRANSFERRATE ANZAHL-MILLISEKUNDEN]
[NO FILE SYSTEM CACHING | FILE SYSTEM CACHING]
[AUTORESIZE {NO | YES}] [INITIALSIZE GANZZAHL {K |M |G}]
[INCREASESIZE GANZZAHL {PERCENT |K |M |G}] [MAXSIZE {NONE | GANZZAHL {K |M |G}}]

KONFIGURATIONSSCHLüSSEL:
MEM_PERCENT, WORKLOAD_TYPE, NUM_STMTS, TPM, ADMIN_PRIORITY
NUM_LOCAL_APPS, NUM_REMOTE_APPS, ISOLATION, BP_RESIZEABLE.

CREATE TOOLS CATALOG

CREATE TOOLS CATALOG KATALOGNAME {CREATE NEW DATABASE DATENBANKNAME |
USE EXISTING [TABLESPACE TABBEREICHSNAME IN] DATABASE DATENBANKNAME}
[FORCE] [KEEP INACTIVE]

DEACTIVATE DATABASE

DEACTIVATE DATABASE ALIASNAME-DER-DATENBANK [USER BENUTZERNAME [USING KENWORT]] [[MEMBER] MEMBERNUMMER] [FORCE]

DECOMPOSE XML DOCUMENT

DECOMPOSE XML DOCUMENT XML-DOKUMENTNAME XMLSCEHMA XML-SCHEMANAME [VALIDATE]

DECOMPOSE XML DOCUMENTS

DECOMPOSE XML DOCUMENTS IN SELECT-ANWEISUNG XMLSCHEMA XML-SCHEMANAME
[VALIDATE] [ALLOW NO ACCESS | ALLOW ACCESS] [COMMITCOUNT GANZE-ZAHL] [CONTINUE_ON_ERROR]
[MESSAGES NACHRICHTENDATEI]

DEREGISTER

DEREGISTER [DB2 SERVER] [IN] NWBINDERY USER BENUTZER [PASSWORD KENNWORT]

DEREGISTER [DB2 SERVER] [IN] LDAP NODE KNOTENNAME
[USER BENUTZER [PASSWORD KENNWORT]]

DESCRIBE

DESCRIBE {[OUTPUT] {SELECT-ANWEISUNG | CALL-ANWEISUNG |
XQUERY XQUERY-ANWEISUNG} |
{TABLE | {[RELATIONAL DATA | XML DATA | TEXT SEARCH] INDEXES |
DATA PARTITIONS} FOR TABLE} TABELLENNAME [SHOW DETAIL]}

DETACH

DETACH

DROP CONTACT

DROP CONTACT NAME-DES-ANSPRECHPARTNERS

DROP CONTACTGROUP

DROP CONTACTGROUP NAME-DER-ANSPRECHPARTNERGRUPPE

DROP DATABASE

DROP DATABASE ALIASNAME-DER-DATENBANK [AT DBPARTITIONNUM]

DROP DBPARTITIONNUM

DROP DBPARTITIONNUM VERIFY

DROP TOOLS CATALOG

DROP TOOLS CATALOG KATALOGNAME IN DATABASE DATENBANKNAME [FORCE]

ECHO

ECHO [ZEICHENFOLGE]

EDIT

{EDIT | E} [EDITOR EDITOR] [BEFEHLSNUMMER]

EXPORT

EXPORT TO DATEINAME OF {IXF | DEL | WSF}
[LOBS TO LOB-PFAD [ {,LOB-PFAD} ... ] ][LOBFILE LOB-DATEI [ {,LOB-DATEI} ... ] ]
[XML TO XML-PFAD [ {,XML-PFAD} ... ] ][XMLFILE DATEINAME [ {,DATEINAME} ... ] ]
[MODIFIED BY {DATEITYPäNDERUNGSWERT ...}][XMLSAVESCHEMA]
[METHOD N ( SPALTE [ {,SPALTE} ... ] )] [MESSAGES NACHRICHTENDATEI]
{SELECT-ANWEISUNG | XQUERY XQUERY-ANWEISUNG |
HIERARCHY {STARTING UNTERGEORDNETE-TABELLE |
(UNTERGEORDNETE-TABELLE [{, UNTERGEORDNETE-TABELLE} ...])} [WHERE ...] }
DATEITYPäNDERUNGSWERT:
NODOUBLEDEL, LOBSINFILE, CHARDELX, COLDELX, DECPLUSBLANK
DECPTX, DATESISO, 1, 2, 3, 4, CODEPAGE=X, STRIPLZEROS, NOCHARDEL,
LOBSINSEPFILES, XMLINSEPFILES, XMLCHAR, XMLGRAPHIC, XMLNODECLARATION,
TIMESTAMPFORMAT=X

FORCE APPLICATION

FORCE APPLICATION {ALL | ( ANWENDUNGSKENNZ. [ {,ANWENDUNGSKENNZ.} ... ] )}
[MODE ASYNC]

GET ADMIN CFG

GET ADMIN CONFIGURATION [FOR NODE KNOTENNAME [USER BENUTZERNAME USING KENNWORT]]

GET CLI CFG

GET CLI CONFIGURATION [AT GLOBAL LEVEL] [FOR SECTION ABSCHNITTNAME]

GET DB CFG

GET DATABASE CONFIGURATION [FOR ALIASNAME-DER-DATENBANK] [SHOW DETAIL]

GET DBM CFG

GET DATABASE MANAGER CONFIGURATION [SHOW DETAIL]

GET ALERT CFG

GET ALERT CONFIGURATION FOR {{CONTAINERS | DATABASE MANAGER | DATABASES |
TABLESPACES} [DEFAULT] | {CONTAINER CONTAINERNAME FOR TABBEREICHSNAME |
DATABASE | TABLESPACE TABBEREICHSNAME} ON ALIASNAME-DER-DATENBANK}
[USING NAME-DES-DIAGNOSEANZEIGERS [ {,NAME-DES-DIAGNOSEANZEIGERS} ... ]]

GET CONNECTION STATE

GET CONNECTION STATE

GET CONTACTGROUP

GET CONTACTGROUP NAME-DER-ANSPRECHPARTNERGRUPPE

GET CONTACTGROUPS

GET CONTACTGROUPS

GET CONTACTS

GET CONTACTS

GET DBM MONITOR SWITCHES

GET DATABASE MANAGER MONITOR SWITCHES
[AT MEMBER MEMBERNUMMER | GLOBAL]

GET DESCRIPTION FOR HEALTH

GET DESCRIPTION FOR HEALTH INDICATOR KURZNAME

GET HEALTH SNAPSHOT

GET HEALTH SNAPSHOT FOR {DATABASE MANAGER | ALL DATABASES |
{ALL | DATABASE | TABLESPACES} ON ALIASNAME-DER-DATENBANK}
[AT MEMBER MEMBERNUMMER | GLOBAL] [SHOW DETAIL]
[WITH FULL COLLECTION]

GET INSTANCE

GET INSTANCE

GET MONITOR SWITCHES

GET MONITOR SWITCHES
[AT MEMBER MEMBERNUMMER | GLOBAL]

GET NOTIFICATION LIST

GET {HEALTH NOTIFICATION CONTACT | NOTIFICATION} LIST

GET RECOMMENDATIONS

GET RECOMMENDATIONS FOR HEALTH INDICATOR KURZNAME
[FOR {DBM | TABLESPACE TABELLENBEREICHSNAME ON ALIASNAME-DER-DATENBANK
| CONTAINER CONTAINERNAME FOR TABLESPACE TABELLENBEREICHSNAME ON ALIASNAME-DER-DATENBANK
| DATABASE ON ALIASNAME-DER-DATENBANK} [AT MEMBER MEMBERNUMMER | GLOBAL]]

GET ROUTINE

GET ROUTINE INTO DATEINAME FROM [SPECIFIC] PROCEDURE ROUTINENNAME [HIDE BODY]

GET SNAPSHOT

GET SNAPSHOT FOR {DATABASE MANAGER | ALL [DCS] DATABASES |
ALL [DCS] APPLICATIONS | ALL BUFFERPOOLS | [DCS] APPLICATION
{APPLID ANW-ID | AGENTID ANW-KENNUNG} | FCM FOR ALL DBPARTITIONNUMS |
LOCKS FOR APPLICATION {APPLID ANW-ID | AGENTID ANW-KENNUNG} |
{ALL | [DCS] DATABASE | [DCS] APPLICATIONS | TABLES |
TABLESPACES | LOCKS | BUFFERPOOLS | DYNAMIC SQL [ZU-SCHREIBENDE-DATEI]}
ON ALIASNAME-DER-DATENBANK} [AT MEMBER MEMBERNUMMER | GLOBAL]

HELP

ANWEISUNGEN ZUM LESEN VON HILFEANZEIGEN:
[ ] SCHLIEßT OPTIONALE PARAMETER EIN
{ } SCHLIEßT VERBINDLICHE PARAMETER EIN
| TRENNT ZWEI ODER MEHR PARAMETER, VON DENEN NUR EINER ANGEGEBEN WERDEN KANN
... GIBT EINEN WIEDERHOLBAREN PARAMETER AN.
SCHLüSSELWöRTER UND RESERVIERTE WöRTER WERDEN IN GROßBUCHSTABEN ANGEGEBEN UND SIND VERBINDLICH.

BEISPIEL:
CONNECT TO ALIASNAME [IN {SHARE | EXCLUSIVE} MODE]
[USER BENUTZER [USING KENNWORT]]

GIBT AN, DASS FOLGENDE ANWEISUNGEN GüLTIG SIND:
CONNECT TO SAMPLE
CONNECT TO SAMPLE IN SHARE MODE
CONNECT TO SAMPLE IN EXCLUSIVE MODE
CONNECT TO SAMPLE IN SHARE MODE USER BENUTZER USING KENNWORT

GLEICHZEITIG SIND FOLGENDE ANWEISUNGEN UNGüLTIG:
CONNECT TO SAMPLE IN MODE (SHARE ODER EXCLUSIVE SIND ERFORDERLICH)
CONNECT TO SAMPLE IN SHARE EXCLUSIVE MODE (ENTWEDER SHARE ODER EXCLUSIVE ANGEBEN)
CONNECT TO SAMPLE USING KENNWORT (KENNWORT UND BENUTZERNAMEN ANGEBEN)

AUF MANCHEN PLATTFORMEN IST HELP AUCH ALS BEFEHL ZUM ZUGRIFF AUF DIE
ONLINEDOKUMENTE 'COMMAND REFERENCE' UND 'SQL REFERENCE' VERFüGBAR.

DIE SYNTAX DES BEFEHLS HELP IST WIE FOLGT:
HELP [ZEICHENFOLGE]

HISTORY

{HISTORY | H} [REVERSE | R] [ANZAHL-BEFEHLE]

IMPORT

IMPORT FROM DATEINAME OF {IXF | ASC | DEL | WSF}
[LOBS FROM LOB-PFAD [ {,LOB-PFAD} ... ] ]
[XML FROM XML-PFAD [ {,XML-PFAD} ... ] ][MODIFIED BY DATEITYPäNDERUNGSWERT ...]
[METHOD {L ( SPALTENANFANG SPALTENENDE [ {,SPALTENANFANG SPALTENENDE} ... ] )
[NULL INDICATORS (SPALTENPOSITION [ {,SPALTENPOSITION} ... ] )] |
N ( SPALTENNAME [ {,SPALTENNAME} ... ] ) |
P ( SPALTENPOSITION [ {,SPALTENPOSITION} ... ] )}]
[XMLPARSE {STRIP | PRESERVE} WHITESPACE]
[XMLVALIDATE USING {XDS [DEFAULT SCHEMA-SQLID]
[IGNORE (SCHEMA-SQLID [ {,SCHEMA-SQLID} ... ])]
[MAP ((SCHEMA-SQLID,SCHEMA-SQLID) [ {(SCHEMA-SQLID,SCHEMA-SQLID)} ... ])] |
SCHEMA SCHEMA-SQLID | SCHEMALOCATION HINTS }]
[ALLOW {NO | WRITE} ACCESS]
[COMMITCOUNT {N | AUTOMATIC}] [{RESTARTCOUNT | SKIPCOUNT} N]
[ROWCOUNT N] [WARNINGCOUNT N] [NOTIMEOUT] [MESSAGES NACHRICHTENDATEI]
{{INSERT | INSERT_UPDATE | REPLACE | REPLACE_CREATE}
INTO {TABELLENNAME [( EINZUFüGENDE-SPALTE , ... )] | HIERARCHIEBESCHREIBUNG}
| CREATE INTO {TABELLENNAME [( EINZUFüGENDE-SPALTE , ... )] |
HIERARCHIEBESCHREIBUNG {AS ROOT TABLE | UNDER UNTERGEORD.-TABELLE}
[IN TABBEREICHSNAME [INDEX IN TABBEREICHSNAME] [LONG IN TABBEREICHSNAME]]}
DATEITYPäNDERUNGSWERT:
COMPOUND=X, INDEXSCHEMA=SCHEMA, FORCEIN, INDEXIXF, IMPLIEDDECIMAL,
NOCHECKLENGTHS, NOEOFCHAR, NULLINDCHAR=X, RECLEN=X, STRIPTBLANKS,
STRIPTNULLS, NO_TYPE_ID, NODOUBLEDEL, LOBSINFILE, USEDEFAULTS,
CHARDELX, COLDELX, DLDELX, DECPLUSBLANK, DECPTX, DATESISO,
DELPRIORITYCHAR, IDENTITYMISSING, IDENTITYIGNORE,
GENERATEDMISSING, GENERATEDIGNORE, DATEFORMAT=X, TIMEFORMAT=X,
TIMESTAMPFORMAT=X, KEEPBLANKS, CODEPAGE=X, NOROWWARNINGS,
NOCHARDEL, NODEFAULTS, USEGRAPHICCODEPAGE, FORCECREATE, XMLCHAR,
XMLGRAPHIC, SECLABELCHAR, SECLABELNAME
HIERARCHIEBESCHREIBUNG:
{ALL TABLES | (UNTERGEORDNETE-TABELLE [(EINZUFüGENDE-SPALTE, ...)], ...)} [IN]
HIERARCHY {STARTING UNTERGEORDNETE-TABELLE | (UNTERGEORDNETE-TABELLE, ...)}

INITIALIZE TAPE

INITIALIZE TAPE [ON ] [USING ]
IST EIN GüLTIGER BANDEINHEITENNAME
DER STANDARD BEI WINDOWS NT IST \\.\TAPE0
IST DER BLOCKUNGSFAKTOR FüR DAS BAND
MUSS EIN FAKTOR ODER EIN VIELFACHES VON 4096 SEIN
DER STANDARD IST DIE STANDARDBLOCKGRößE FüR DIE EINHEIT

INSPECT

INSPECT {CHECK {DATABASE [BEGIN TBSPACEID
[OBJECTID ]] [CATALOG TO TABLESPACE CONSISTENCY] |
TABLESPACE {NAME | TBSPACEID }
[BEGIN OBJECTID ] [CATALOG TO TABLESPACE CONSISTENCY] |
TABLE {NAME [SCHEMA ] | TBSPACEID
OBJECTID }} [FOR ERROR STATE ALL]
[LIMIT ERROR TO {DEFAULT | | ALL}] [] |
FORMAT XML IN {NAME
[SCHEMA ] | TBSPACEID OBJECTID }
[{LOGICAL | PHYSICAL}] PAGES FIRST [NUMBER ]
[PASSWORD ]}
{ROWCOMPESTIMATE TABLE {NAME [SCHEMA ] |
TBSPACEID OBJECTID }}
RESULTS [KEEP] []

EBENENKLAUSEL:
[EXTENTMAP ] [DATA ] [BLOCKMAP ]
[INDEX ] [LONG ] [LOB [XML ] [COL ] [INDEXDATA]

EBENENWERT:
{NORMAL | NONE | LOW}

FORMATWERT:
{BRIEF | DETAIL | HEX}

ON-DBPARTITIONNUM-KLAUSEL:
ON {{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ... ) | ALL DBPARTITIONNUMS [EXCEPT
{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ...)]}

LIST PACKAGES

LIST PACKAGES [FOR {USER | ALL | SYSTEM | SCHEMA SCHEMANAME}] [SHOW DETAIL]

LIST TABLES

LIST TABLES [FOR {USER | ALL | SYSTEM | SCHEMA SCHEMANAME}] [SHOW DETAIL]

LIST ACTIVE DATABASES

LIST ACTIVE DATABASES [AT MEMBER MEMBERNUMMER | GLOBAL]

LIST APPLICATIONS

LIST APPLICATIONS [FOR DATABASE ALIASNAME-DER-DATENBANK]
[AT MEMBER MEMBERNUMMER| GLOBAL] [SHOW DETAIL]

LIST COMMAND OPTIONS

LIST COMMAND OPTIONS

LIST DATABASE DIRECTORY

LIST DATABASE DIRECTORY [ON LAUFWERK]

LIST DB PARTITION GROUPS

LIST DATABASE PARTITION GROUPS [SHOW DETAIL]

LIST DBPARTITIONNUMS

LIST DBPARTITIONNUMS

LIST DCS APPLICATIONS

LIST DCS APPLICATIONS [SHOW DETAIL | EXTENDED]

LIST DCS DIRECTORY

LIST DCS DIRECTORY

LIST DRDA INDOUBT

LIST DRDA INDOUBT TRANSACTIONS [WITH PROMPTING]

LIST HISTORY

LIST HISTORY {BACKUP | ROLLFORWARD | REORG |
CREATE TABLESPACE | ALTER TABLESPACE | DROPPED TABLE | LOAD |
RENAME TABLESPACE | ARCHIVE LOG}
{ALL | SINCE ZEITMARKE |CONTAINING {SCHEMA.OBJEKTNAME | OBJEKTNAME}}
FOR [DATABASE] ALIASNAME-DER-DATENBANK

LIST INDOUBT TRANSACTIONS

LIST INDOUBT TRANSACTIONS [WITH PROMPTING]

LIST NODE DIRECTORY

LIST [ADMIN] NODE DIRECTORY [SHOW DETAIL]

LIST ODBC DATA SOURCES

LIST [USER | SYSTEM] ODBC DATA SOURCES

LIST TABLESPACE CONTAINERS

LIST TABLESPACE CONTAINERS FOR TABELLENBEREICHS-ID [SHOW DETAIL]

LIST TABLESPACES

LIST TABLESPACES [SHOW DETAIL]

LIST UTILITIES

LIST UTILITIES [SHOW DETAIL]

LOAD

LOAD QUERY TABLE TABELLENNAME [TO LOKALE-NACHRICHTENDATEI]
[NOSUMMARY | SUMMARYONLY] [SHOWDELTA]

LOAD [CLIENT] FROM DATEI/PIPE/EINHEIT/CURSORNAME [ {,DATEI/PIPE/EINHEIT} ... ]
OF {ASC | DEL | IXF | CURSOR}
[LOBS FROM LOB-PFAD [ {,LOB-PFAD} ... ] ]
[XML FROM XML-PFAD [ {,XML-PFAD} ... ] ]
[MODIFIED BY DATEITYPäNDERUNGSWERT [ {DATEITYPäNDERUNGSWERT} ... ] ]]
[METHOD {L ( SPALTENANFANG SPALTENENDE [ {,SPALTENANFANG SPALTENENDE} ... ] )
[NULL INDICATORS (SPALTENPOSITION [ {,SPALTENPOSITION} ... ] )]
| N ( SPALTENNAME [ {,SPALTENNAME} ... ] )
| P ( SPALTENPOSITION [ {,SPALTENPOSITION} ... ] )}]
[XMLPARSE {STRIP | PRESERVE} WHITESPACE]
[XMLVALIDATE USING {XDS [DEFAULT SCHEMA-SQLID]
[IGNORE (SCHEMA-SQLID [ {,SCHEMA-SQLID} ... ])]
[MAP ((SCHEMA-SQLID,SCHEMA-SQLID) [ {(SCHEMA-SQLID,SCHEMA-SQLID)} ... ])] |
SCHEMA SCHEMA-SQLID | SCHEMALOCATION HINTS }]
[SAVECOUNT N]
[ROWCOUNT N] [WARNINGCOUNT N] [MESSAGES NACHRICHTENDATEI]
[TEMPFILES PATH PFADNAME]
{INSERT | REPLACE [{KEEPDICTIONARY | RESETDICTIONARY}] | RESTART | TERMINATE}
INTO TABELLENNAME [( EINZUFüGENDE-SPALTE [ {,EINZUFüGENDE-SPALTE} ... ] )]
[FOR EXCEPTION TABELLENNAME [NOUNIQUEEXC NORANGEEXC]]
[STATISTICS {NO | USE PROFILE}]
[{COPY {NO | YES { USE TSM [OPEN ANZAHL-SITZUNGEN SESSIONS]
| TO VERZEICHNIS/EINHEIT [ {,VERZEICHNIS/EINHEIT} ... ]
| LOAD BIBLIOTHEKSNAME [OPEN ANZAHL-SITZUNGEN SESSIONS]}}
| NONRECOVERABLE} ]
[HOLD QUIESCE] [WITHOUT PROMPTING] [DATA BUFFER PUFFERGRößE]
[SORT BUFFER PUFFERGRößE] [CPU_PARALLELISM N] [DISK_PARALLELISM N]
[FETCH_PARALLELISM {YES | NO}
[INDEXING MODE {AUTOSELECT | REBUILD | INCREMENTAL | DEFERRED}]
[ALLOW NO ACCESS | ALLOW READ ACCESS [USE TABBEREICHSNAME]]
[SET INTEGRITY PENDING CASCADE {DEFERRED | IMMEDIATE}] [LOCK WITH FORCE]
[SOURCEUSEREXIT AUSFüHRBARE-DATEI [REDIRECT {[INPUT FROM {[BUFFER EINGABEPUFFER] |
[FILE EINGABEDATEI]} [OUTPUT TO FILE AUSGABEDATEI]
[OUTPUT TO FILE AUSGABEDATEI]] [PARALLELIZE]]
[[PARTITIONED DB CONFIG] OPTION-FüR-PARTITIONIERTE-DATENBANK [{OPTION-FüR-PARTITIONIERTE-DATENBANK}...]]
DATEITYPäNDERUNGSWERT:
NOROWWARNINGS, ANYORDER, BINARYNUMERICS, CODEPAGE=X,
DUMPFILE=X, FASTPARSE, NOHEADER, TOTALFREESPACE=X,
INDEXFREESPACE=X, PAGEFREESPACE=X, FORCEIN, IMPLIEDDECIMAL,
PACKEDDECIMAL, NOCHECKLENGTHS, NOEOFCHAR, NULLINDCHAR=X,
RECLEN=X, STRIPTBLANKS, STRIPTNULLS, NODOUBLEDEL, LOBSINFILE,
CHARDELX, COLDELX, DLDELX, DECPLUSBLANK, DECPTX, DATESISO,
DELPRIORITYCHAR, USEDEFAULTS, DATEFORMAT=X, TIMEFORMAT=X,
TIMESTAMPFORMAT=X, ZONEDDECIMAL, KEEPBLANKS, IDENTITYMISSING,
IDENTITYIGNORE, IDENTITYOVERRIDE, GENERATEDMISSING,
GENERATEDIGNORE, GENERATEDOVERRIDE, USEGRAPHICCODEPAGE,
SECLABELCHAR, SECLABELNAME, XMLCHAR, XMLGRAPHIC, NOCHARDEL
OPTION-FüR-PARTITIONIERTE-DATENBANK:
PART_FILE_LOCATION X, OUTPUT_DBPARTNUMS X,
PARTITIONING_DBPARTNUMS X, MODE X, MAX_NUM_PART_AGENTS X, OMIT_HEADER,
ISOLATE_PART_ERRS X, STATUS_INTERVAL X, PORT_RANGE X, CHECK_TRUNCATION,
MAP_FILE_INPUT X, MAP_FILE_OUTPUT X, TRACE X, NEWLINE, DISTFILE X

LOAD QUERY

LOAD QUERY TABLE TABELLENNAME [TO LOKALE-NACHRICHTENDATEI]
[NOSUMMARY | SUMMARYONLY] [SHOWDELTA]

PING

PING ALIASNAME-DER-DATENBANK [REQUEST PAKETGRößE] [RESPONSE PAKETGRößE] [ANZAHL-DER-ITERATIONEN [TIME|TIMES]]

PRECOMPILE

{PREP | PRECOMPILE} DATEINAME [ACTION {ADD | REPLACE [RETAIN {YES | NO}]
[REPLVER VERSIONS-ID]}] [APREUSE {YES | NO}] [BINDFILE [USING BINDEDATEI]]
[BLOCKING {UNAMBIG | ALL | NO}] [CALL_RESOLUTION {IMMEDIATE | DEFERRED}]
[COLLECTION SCHEMANAME] [CONNECT {1 | 2}] [COMPATIBILITY_MODE ORA]
[CONCURRENTACCESSRESOLUTION {USE_CURRENTLY_COMMITTED | USE CURRENTLY COMMITTED
| USECURRENTLYCOMMITTED | WAIT_FOR_OUTCOME | WAIT FOR OUTCOME | WAITFOROUTCOME}]
[DATETIME {DEF | USA | EUR | ISO | JIS | LOC}] [DECTYPE {NOCONVERT | CONVERT}]
[DEFERRED_PREPARE {NO | YES | ALL}] [DEGREE {1 | GRAD-DER-PARALLELITäT | ANY}]
[DISCONNECT {EXPLICIT | CONDITIONAL | AUTOMATIC}]
[DYNAMICRULES {BIND | RUN | INVOKEBIND | INVOKERUN | DEFINEBIND | DEFINERUN}]
[EXPLAIN {NO | YES | REOPT | ALL | ONLY}] [EXPLSNAP {NO | YES | REOPT | ALL}]
[EXTENDEDINDICATOR {NO | YES}]
[FEDERATED {NO | YES}] [FUNCPATH SCHEMANAME [{,SCHEMANAME} ... ]]
[FEDERATED_ASYNCHRONY {ANY | ANZAHL-ATQS-IM-PLAN}]
[GENERIC ZEICHENFOLGE] [INSERT {DEF | BUF}] [ISOLATION {CS |RR |UR |RS |NC}]
[LANGLEVEL {SAA1|MIA|SQL92E}] [LEVEL KONSISTENZTOKEN] [LONGERROR {YES NO}]
[MESSAGES NACHRICHTENDATEI] [NOLINEMACRO] [OPTLEVEL {0 | 1}] [OUTPUT DATEINAME]
[OPTPROFILE OPTIMIERUNGSPROFILNAME] [OWNER BERECHTIGUNGS-ID]
[PACKAGE [USING PAKETNAME]] [PREPROCESSOR "VORPROZESSORBEFEHL"]
[QUALIFIER QUALIFIKATIONSNAME] [QUERYOPT OPTIMIERUNGSSTUFE]
[REOPT {NONE | ONCE | ALWAYS}]
[SQLCA {SAA | NONE}] [SQLERROR {NOPACKAGE | CHECK | CONTINUE}]
[SQLFLAG {MVSDB2V23 | MVSDB2V31 | MVSDB2V41 | SQL92E} SYNTAX]
[SQLRULES {DB2 | STD}] [SQLWARN {YES | NO}]
[STATICREADONLY {NO | YES | INSENSITIVE}] [STRING_UNITS {SYSTEM | CODEUNITS32}]
[SYNCPOINT {ONEPHASE | TWOPHASE | NONE}] [SYNTAX]
[TARGET {IBMCOB | MFCOB | MFCOB16 | C | CPLUSPLUS | FORTRAN | ANSI_COBOL |
BORLAND_C | BORLAND_CPLUSPLUS}] [TRANSFORM GROUP UMSETZUNGSGRUPPE]
[UNSAFENULL {NO | YES}] [VALIDATE {RUN | BIND}]
[WCHARTYPE {CONVERT | NOCONVERT}] [VERSION VERSIONS-ID]
*******************************************************************************
* DIE FOLGENDEN OPTIONEN GELTEN NUR, WENN EINE VERBINDUNG ZU EINEM HOST ODER ISERIES-SERVER BESTEHT *
*******************************************************************************
[CCSIDG DBCS-CCSID] [CCSIDM MISCH-CCSID] [CCSIDS SBCS-CCSID]
[CHARSUB {DEFAULT | BIT | SBCS | MIXED}] [CNULREQD {YES | NO}]
[DBPROTOCOL {DRDA | PRIVATE}] [DEC {31 | 15}] [DECDEL {PERIOD | COMMA}]
[ENCODING {ASCII | EBCDIC | UNICODE | CCSID}] [IMMEDWRITE {NO | YES | PH1}]
[KEEPDYNAMIC {NO | YES}] [OPTHINT HINWEIS-ID] [OS400NAMING {SQL | SYSTEM}]
[PATH SCHEMANAME] [RELEASE {COMMIT | DEALLOCATE}]
[SORTSEQ {HEX | JOBRUN}] [STRDEL {APOSTROPHE | QUOTE}] [TEXT BEZEICHNUNG]

PREP

{PREP | PRECOMPILE} DATEINAME [ACTION {ADD | REPLACE [RETAIN {YES | NO}]
[REPLVER VERSIONS-ID]}] [APREUSE {YES | NO}] [BINDFILE [USING BINDEDATEI]]
[BLOCKING {UNAMBIG | ALL | NO}] [CALL_RESOLUTION {IMMEDIATE | DEFERRED}]
[COLLECTION SCHEMANAME] [CONNECT {1 | 2}] [COMPATIBILITY_MODE ORA]
[CONCURRENTACCESSRESOLUTION {USE_CURRENTLY_COMMITTED | USE CURRENTLY COMMITTED
| USECURRENTLYCOMMITTED | WAIT_FOR_OUTCOME | WAIT FOR OUTCOME | WAITFOROUTCOME}]
[DATETIME {DEF | USA | EUR | ISO | JIS | LOC}] [DECTYPE {NOCONVERT | CONVERT}]
[DEFERRED_PREPARE {NO | YES | ALL}] [DEGREE {1 | GRAD-DER-PARALLELITäT | ANY}]
[DISCONNECT {EXPLICIT | CONDITIONAL | AUTOMATIC}]
[DYNAMICRULES {BIND | RUN | INVOKEBIND | INVOKERUN | DEFINEBIND | DEFINERUN}]
[EXPLAIN {NO | YES | REOPT | ALL | ONLY}] [EXPLSNAP {NO | YES | REOPT | ALL}]
[EXTENDEDINDICATOR {NO | YES}]
[FEDERATED {NO | YES}] [FUNCPATH SCHEMANAME [{,SCHEMANAME} ... ]]
[FEDERATED_ASYNCHRONY {ANY | ANZAHL-ATQS-IM-PLAN}]
[GENERIC ZEICHENFOLGE] [INSERT {DEF | BUF}] [ISOLATION {CS |RR |UR |RS |NC}]
[LANGLEVEL {SAA1|MIA|SQL92E}] [LEVEL KONSISTENZTOKEN] [LONGERROR {YES NO}]
[MESSAGES NACHRICHTENDATEI] [NOLINEMACRO] [OPTLEVEL {0 | 1}] [OUTPUT DATEINAME]
[OPTPROFILE OPTIMIERUNGSPROFILNAME] [OWNER BERECHTIGUNGS-ID]
[PACKAGE [USING PAKETNAME]] [PREPROCESSOR "VORPROZESSORBEFEHL"]
[QUALIFIER QUALIFIKATIONSNAME] [QUERYOPT OPTIMIERUNGSSTUFE]
[REOPT {NONE | ONCE | ALWAYS}]
[SQLCA {SAA | NONE}] [SQLERROR {NOPACKAGE | CHECK | CONTINUE}]
[SQLFLAG {MVSDB2V23 | MVSDB2V31 | MVSDB2V41 | SQL92E} SYNTAX]
[SQLRULES {DB2 | STD}] [SQLWARN {YES | NO}]
[STATICREADONLY {NO | YES | INSENSITIVE}] [STRING_UNITS {SYSTEM | CODEUNITS32}]
[SYNCPOINT {ONEPHASE | TWOPHASE | NONE}] [SYNTAX]
[TARGET {IBMCOB | MFCOB | MFCOB16 | C | CPLUSPLUS | FORTRAN | ANSI_COBOL |
BORLAND_C | BORLAND_CPLUSPLUS}] [TRANSFORM GROUP UMSETZUNGSGRUPPE]
[UNSAFENULL {NO | YES}] [VALIDATE {RUN | BIND}]
[WCHARTYPE {CONVERT | NOCONVERT}] [VERSION VERSIONS-ID]
*******************************************************************************
* DIE FOLGENDEN OPTIONEN GELTEN NUR, WENN EINE VERBINDUNG ZU EINEM HOST ODER ISERIES-SERVER BESTEHT *
*******************************************************************************
[CCSIDG DBCS-CCSID] [CCSIDM MISCH-CCSID] [CCSIDS SBCS-CCSID]
[CHARSUB {DEFAULT | BIT | SBCS | MIXED}] [CNULREQD {YES | NO}]
[DBPROTOCOL {DRDA | PRIVATE}] [DEC {31 | 15}] [DECDEL {PERIOD | COMMA}]
[ENCODING {ASCII | EBCDIC | UNICODE | CCSID}] [IMMEDWRITE {NO | YES | PH1}]
[KEEPDYNAMIC {NO | YES}] [OPTHINT HINWEIS-ID] [OS400NAMING {SQL | SYSTEM}]
[PATH SCHEMANAME] [RELEASE {COMMIT | DEALLOCATE}]
[SORTSEQ {HEX | JOBRUN}] [STRDEL {APOSTROPHE | QUOTE}] [TEXT BEZEICHNUNG]

PRUNE HISTORY

PRUNE HISTORY ZEITMARKE [WITH FORCE OPTION] [AND DELETE]

PRUNE LOGFILE

PRUNE LOGFILE PRIOR TO PROTOKOLLDATEINAME

PUT ROUTINE

PUT ROUTINE FROM DATEINAME [OWNER NEUER-EIGNER [USE REGISTERS]]

QUERY CLIENT

QUERY CLIENT

QUIESCE DATABASE

QUIESCE DATABASE {IMMEDIATE | DEFER [WITH TIMEOUT MINUTEN]}
[FORCE CONNECTIONS]

QUIESCE INSTANCE

QUIESCE INSTANCE INSTANZNAME [USER BENUTZERNAME | GROUP GRUPPENNAME]
[RESTRICTED ACCESS] {IMMEDIATE | DEFER [WITH TIMEOUT MINUTEN]}
[FORCE CONNECTIONS]

QUIESCE TABLESPACES

QUIESCE TABLESPACES FOR TABLE {TABELLENNAME | SCHEMA.TABELLENNAME}
{SHARE | INTENT TO UPDATE | EXCLUSIVE | RESET}

QUIT

QUIT

REBIND

REBIND [PACKAGE] PAKETNAME [VERSION VERSIONS-ID] [APREUSE {YES | NO}]
[RESOLVE {ANY | CONSERVATIVE}] [REOPT {NONE | ONCE | ALWAYS}]
[FUNCPATH SCHEMANAME [ {,SCHEMANAME} ... ]]

RECOVER

RECOVER DATABASE ALIASNAME-DER-DATENBANK [TO {ISO-ZEIT
[USING LOCAL TIME | USING UTC TIME] [ON ALL DBPARTITIONNUMS] |
END OF LOGS [ON-DBPARTITIONNUM-KLAUSEL]}] [USER BENUTZERNAME
[USING KENNWORT]] [USING HISTORY FILE (PROTOKOLLDATEI [{, PROTOKOLLDATEI
ON DBPARTITIONNUM DATENBANKPARTITIONSNUMMER} ... ])] [OVERFLOW LOG PATH
(PROTOKOLLVERZEICHNIS [{,PROTOKOLLVERZEICHNIS ON DBPARTITIONNUM DATENBANKPARTITIONSNUMMER} ... ])]
[COMPRLIB BIBLIOTHEKSNAME] [COMPROPTS OPTIONSZEICHENFOLGE] [RESTART]

ON-DBPARTITIONNUM-KLAUSEL:
ON {{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ... ) | ALL DBPARTITIONNUMS [EXCEPT
{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ...)]}

REDISTRIBUTE DB PARTITION

REDISTRIBUTE DATABASE PARTITION GROUP DATENBANKPARTITIONSGRUPPE
{NOT ROLLFORWARD RECOVERABLE AKTION [OPTIONEN_FüR_NICHT_AKTUALISIEREND_WIEDERHERSTELLBAR]} | {AKTION}
[TABLE (TABELLENNAME[{,TABELLENNAME}...}) [ONLY | FIRST]]
[EXCLUDE (TABELLENNAME [{,TABELLENNAME} ...])]
[STOP AT LOKALE_ISO-ZEIT]
AKTION:
{UNIFORM | USING DISTFILE DISTFILENAME} [DATENBANKPARTITION_HINZUFüGEN_ENTFERNEN] |
USING TARGETMAP NAME-DER-ZIELZUORDNUNGSDATEI | CONTINUE | ABORT
DATENBANKPARTITION_HINZUFüGEN_ENTFERNEN:
{ADD | DROP} {DBPARTITIONNUM | DBPARTITIONNUMS} (N [TO M] [{,N [TO M]} ...])
OPTIONEN_FüR_NICHT_AKTUALSIEREND_WIEDERHERSTELLBAR:
[DATA BUFFER N]
[INDEXING MODE {REBUILD | DEFERRED} ][PRECHECK {YES | NO | ONLY}]
[STATISTICS {USE PROFILE | NONE}]

REFRESH LDAP

REFRESH LDAP { CLI CFG [AT {USER | GLOBAL} LEVEL]| DB DIRECTORY | NODE DIRECTORY }

REGISTER LDAP

REGISTER [DB2 SERVER] [IN] [ADMIN] LDAP {NODE|AS} KNOTENNAME [PROTOCOL {
APPN NETWORK NETZ-ID PARTNERLU PARTNER-LU MODE MODUS [TPNAME TP-NAME]
[SECURITY {NONE | SAME | PROGRAM}] [LANADDRESS LAN-ADAPTERADRESSE]
[CHGPWDLU KENNWORTäNDERUNGS-LU] |
NPIPE |
{TCPIP | TCPIP4 | TCPIP6} [HOSTNAME HOSTNAME] [SVCENAME SERVICENAME]
[SECURITY SOCKS] }
[REMOTE COMPUTERNAME] [INSTANCE INSTANZNAME] [NODETYPE {SERVER|MPP|DCS}]
[OSTYPE BETRIEBSSYSTEMTYP] [WITH "KOMMENTARZEICHENFOLGE"] [USER BENUTZER [PASSWORD KENNWORT]]

REGISTER XMLSCHEMA

REGISTER XMLSCHEMA SCHEMA-URI FROM INHALTS-URI
[WITH EIGENSCHAFTEN-URI] [AS RELATIONALE-KENNUNG][TEILDOKUMENTKLAUSEL]
[COMPLETE [WITH SCHEMAEIGENSCHAFTEN-URI][ENABLE DECOMPOSITION]]

TEILDOKUMENTKLAUSEL:
ADD DOKUMENT-URI FROM INHALTS-URI [WITH EIGENSCHAFTEN-URI] ...

REGISTER XSROBJECT

REGISTER XSROBJECT SYSTEM-ID [PUBLIC ALLGEMEINE-ID] FROM INHALTS-URI
[AS RELATIONALE-KENNUNG] [DTD | EXTERNAL ENTITY]

REORG INDEXES

REORG {TABLE TABELLENNAME TABELLENKLAUSEL | {INDEXES ALL FOR TABLE TABELLENNAME |
INDEX INDEXNAME [FOR TABLE TABELLENNAME]} INDEXKLAUSEL}
[TABELLENPARTITIONSKLAUSEL] [ON-DBPARTITIONNUM-KLAUSEL]

TABELLENKLAUSEL:
[[CLASSIC] [ALLOW {READ | NO} ACCESS] [USE TABELLENBEREICHSNAME]
[INDEX INDEXNAME] [INDEXSCAN] [LONGLOBDATA [USE LOB-TABELLENBEREICHSNAME]]
[KEEPDICTIONARY | RESETDICTIONARY]] | [INPLACE INPLACE-KLAUSEL] |
[RECLAIM EXTENTS [ALLOW {WRITE | READ | NO} ACCESS]]

INPLACE-KLAUSEL:
[[ALLOW {WRITE | READ} ACCESS] [[FULL] [INDEX INDEXNAME]
[{TRUNCATE | NOTRUNCATE} TABLE] | CLEANUP OVERFLOWS]
[START | RESUME] | {STOP | PAUSE}]

INDEXKLAUSEL:
[ALLOW {READ | NO | WRITE} ACCESS]
[REBUILD | SPEICHERBEREICHSKONSOLIDIERUNGSOPTIONEN]

SPEICHERBEREICHSKONSOLIDIERUNGSOPTIONEN:
[CLEANUP [ALL | PAGES]] [RECLAIM EXTENTS]

TABELLENPARTITIONSKLAUSEL:
ON DATA PARTITION PARTITIONSNAME

ON-DBPARTITIONNUM-KLAUSEL:
ON {{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ... ) | ALL DBPARTITIONNUMS [EXCEPT
{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ...)]}

REORG TABLE

REORG {TABLE TABELLENNAME TABELLENKLAUSEL | {INDEXES ALL FOR TABLE TABELLENNAME |
INDEX INDEXNAME [FOR TABLE TABELLENNAME]} INDEXKLAUSEL}
[TABELLENPARTITIONSKLAUSEL] [ON-DBPARTITIONNUM-KLAUSEL]

TABELLENKLAUSEL:
[[CLASSIC] [ALLOW {READ | NO} ACCESS] [USE TABELLENBEREICHSNAME]
[INDEX INDEXNAME] [INDEXSCAN] [LONGLOBDATA [USE LOB-TABELLENBEREICHSNAME]]
[KEEPDICTIONARY | RESETDICTIONARY]] | [INPLACE INPLACE-KLAUSEL] |
[RECLAIM EXTENTS [ALLOW {WRITE | READ | NO} ACCESS]]

INPLACE-KLAUSEL:
[[ALLOW {WRITE | READ} ACCESS] [[FULL] [INDEX INDEXNAME]
[{TRUNCATE | NOTRUNCATE} TABLE] | CLEANUP OVERFLOWS]
[START | RESUME] | {STOP | PAUSE}]

INDEXKLAUSEL:
[ALLOW {READ | NO | WRITE} ACCESS]
[REBUILD | SPEICHERBEREICHSKONSOLIDIERUNGSOPTIONEN]

SPEICHERBEREICHSKONSOLIDIERUNGSOPTIONEN:
[CLEANUP [ALL | PAGES]] [RECLAIM EXTENTS]

TABELLENPARTITIONSKLAUSEL:
ON DATA PARTITION PARTITIONSNAME

ON-DBPARTITIONNUM-KLAUSEL:
ON {{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ... ) | ALL DBPARTITIONNUMS [EXCEPT
{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ...)]}

REORGCHK

REORGCHK [{UPDATE | CURRENT} STATISTICS]
[ON {TABLE {USER | SYSTEM | ALL | TABELLENNAME} | SCHEMA SCHEMANAME}]

RESET ADMIN CFG

RESET ADMIN CONFIGURATION [FOR NODE KNOTENNAME [USER BENUTZERNAME USING KENNWORT]]

RESET ALERT CFG

RESET ALERT CONFIGURATION FOR {{CONTAINERS | DATABASE MANAGER | DATABASES |
TABLESPACES} | {CONTAINER CONTAINERNAME FOR TABBEREICHSNAME | DATABASE |
TABLESPACE TABBEREICHSNAME} ON ALIASNAME-DER-DATENBANK [USING NAME-DES-DIAGNOSEANZEIGERS]}

RESET DB CFG

RESET DATABASE CONFIGURATION FOR ALIASNAME-DER-DATENBANK [MEMBER MEMBERNUMMER]

RESET DBM CFG

RESET DATABASE MANAGER CONFIGURATION

RESET MONITOR

RESET MONITOR {ALL [DCS] | FOR [DCS] DATABASE ALIASNAME-DER-DATENBANK}
[AT MEMBER MEMBERNUMMER | GLOBAL]

RESTART DATABASE

RESTART DATABASE ALIASNAME-DER-DATENBANK [USER BENUTZER [USING KENNWORT]]
[DROP PENDING TABLESPACES (TABBEREICHSNAME [ {,TABBEREICHSNAME} ... ])]
[WRITE RESUME]

RESTORE DATABASE

RESTORE DATABASE ALIASNAME-DER-QUELLENDATENBANK { RESTOREOPTIONEN | CONTINUE | ABORT }

RESTOREOPTIONEN:
[USER BENUTZER [USING KENNWORT]]
[BESTANDSRESTOREKLAUSEL][INCREMENTAL [AUTOMATIC | ABORT]]
[DATENTRäGERZIELKLAUSEL][TAKEN AT DATE-TIME]
[[TO ZIELVERZEICHNIS] | [ON LAUFWERK[{,LAUFWERK}...][DBPATH ON LAUFWERK]]]
[TRANSPORT [STAGE IN ALIASNAME-DER-ZWISCHENSPEICHERDATENBANK] [USING STOGROUP NAME-DER-SPEICHERGRUPPE]]
[INTO ALIASNAME-DER-ZIELDATENBANK]
[LOGTARGET {{VERZEICHNIS | DEFAULT} | {{INCLUDE | EXCLUDE} [FORCE]}}]
[NEWLOGPATH {VERZEICHNIS | DEFAULT}] [WITH ANZAHL-PUFFER BUFFERS]
[BUFFER PUFFERGRößE] [REPLACE HISTORY FILE] [REPLACE EXISTING]
[REDIRECT [GENERATE SCRIPT DATEINAME]] [PARALLELISM N]
[COMPRLIB BIBLIOTHEKSNAME] [COMPROPTS OPTIONSZEICHENFOLGE]
[WITHOUT ROLLING FORWARD] [WITHOUT PROMPTING]

BESTANDSRESTOREKLAUSEL:
REBUILDOPTIONEN |
TABLESPACE [ONLINE] |
TABLESPACE (TABBEREICHSNAME [ {,TABBEREICHSNAME} ... ])
[SCHEMA (SCHEMANAME [ {,SCHEMANAME} ... ])] [ONLINE] |
HISTORY FILE [ONLINE] |
LOGS [ONLINE] |
COMPRESSION LIBRARY [ONLINE]

DATENTRäGERZIELKLAUSEL:
USE {TSM | XBSA}
[OPEN ANZAHL-SITZUNGEN SESSIONS] | SNAPSHOT [ {LIBRARY | SCRIPT} DATEINAME] ]
[OPTIONS {OPTIONSZEICHENFOLGE | NAME-DER-OPTIONSDATEI}] |
LOAD BIBNAME [OPEN ANZAHL-SITZUNGEN SESSIONS]
[OPTIONS {OPTIONSZEICHENFOLGE | NAME-DER-OPTIONSDATEI}] |
FROM VERZEICHNIS/EINHEIT [{,VERZEICHNIS/EINHEIT} ... ]

REBUILDOPTIONEN:
REBUILD WITH {ALL TABLESPACES IN {DATABASE | IMAGE} [EXCEPT TABLESPACE
(TABBEREICHSNAME [ {,TABBEREICHSNAME} ... ])] | TABLESPACE (TABBEREICHSNAME

REWIND TAPE

REWIND TAPE [ON ]
IST EIN GüLTIGER BANDEINHEITENNAME
DER STANDARD BEI WINDOWS NT IST \\.\TAPE0

ROLLFORWARD DATABASE

ROLLFORWARD DATABASE ALIASNAME-DER-DATENBANK [USER BENUTZER [USING KENNWORT]]
[TO {ISO-ZEIT [ON ALL DBPARTITIONNUMS] [USING LOCAL TIME | USING UTC TIME]} |
{END OF BACKUP [ON ALL DBPARTITIONNUMS]} |
{END OF LOGS [ON-DBPARTITIONNUM-KLAUSEL]}
[AND {COMPLETE | STOP}]] |
[COMPLETE | STOP | CANCEL | {QUERY STATUS [USING LOCAL TIME | USING UTC TIME]}
[ON-DBPARTITIONNUM-KLAUSEL]]
[TABLESPACE ONLINE |
TABLESPACE (TABBEREICHSNAME [ {,TABBEREICHSNAME} ... ]) [ONLINE]]
[OVERFLOW LOG PATH (PROTOKOLLVERZEICHNIS
[{,PROTOKOLLVERZEICHNIS ON DBPARTITIONNUM DATENBANKPARTITIONSNUMMER} ... ])]
[NORETRIEVE]
[RECOVER DROPPED TABLE GELöSCHTE-TABELLEN-ID TO EXPORTVERZEICHNIS]

ON-DBPARTITIONNUM-KLAUSEL:
ON {{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ... ) | ALL DBPARTITIONNUMS [EXCEPT
{DBPARTITIONNUM | DBPARTITIONNUMS} (DATENBANKPARTITIONSNUMMER
[TO DATENBANKPARTITIONSNUMMER] , ...)]}

RUNCMD

{RUNCMD | R} [BEFEHLSNUMMER]

RUNSTATS

RUNSTATS ON {TABLE | VIEW} TABELLENNAME [USE PROFILE | STATISTIKOPTIONEN]

STATISTIKOPTIONEN:
[TABELLENOBJEKTOPTIONEN] [ALLOW {WRITE | READ} ACCESS]
[TABELLENSTICHPROBENOPTIONEN] [INDEXSTICHPROBENOPTIONEN]
[PROFILOPTIONEN] [UTIL_IMPACT_PRIORITY [PRIORITäT]]

TABELLENOBJEKTOPTIONEN:
[{FOR INDEXKLAUSEL [EXCLUDING XML COLUMNS] |
[SPALTENSTATISTIKKLAUSEL] [EXCLUDING XML COLUMNS] [AND INDEXKLAUSEL]}]

TABELLENSTICHPROBENOPTIONEN:
[TABLESAMPLE {BERNOULLI | SYSTEM} (NUMERISCHES-LITERAL)
[REPEATABLE (GANZZAHLIGES-LITERAL)]]

INDEXSTICHPROBENOPTIONEN:
[INDEXSAMPLE {BERNOULLI | SYSTEM} (NUMERISCHES-LITERAL)

PROFILOPTIONEN:
[{SET PROFILE [NONE | ONLY] | UPDATE PROFILE [ONLY] | UNSET PROFILE}]

INDEXKLAUSEL:
[[SAMPLED | UNSAMPLED] DETAILED] {INDEXES | INDEX} {ALL | INDEXNAME
[{,INDEXNAME}...]}

SPALTENSTATISTIKKLAUSEL:
[ON {{ALL | KEY} COLUMNS [AND COLUMNS (SPALTENOPTION [{,SPALTENOPTION}...])] |
COLUMNS (SPALTENOPTION [{,SPALTENOPTION}...])}] [VERTEILUNGSKLAUSEL]

SPALTENOPTION:
{SPALTENNAME [LIKE STATISTICS] | (SPALTENNAME [{,SPALTENNAME}...])}

VERTEILUNGSKLAUSEL:
WITH DISTRIBUTION [ON {{ALL | KEY} COLUMNS [AND COLUMNS (VERTEILUNGSSPALTE
[{,VERTEILUNGSSPALTE}...])] | COLUMNS (DIST-COLUMN [{,VERTEILUNGSSPALTE}...]) }]
[DEFAULT [NUM_FREQVALUES ANZAHL] [NUM_QUANTILES ANZAHL]]

VERTEILUNGSSPALTE:
{SPALTENNAME | (SPALTENNAME [{,SPALTENNAME}...])} [NUM_FREQVALUES ANZAHL]
[NUM_QUANTILES ANZAHL]

SET CLIENT

SET CLIENT [CONNECT {1 | 2}] [DISCONNECT {EXPLICIT | CONDITIONAL | AUTOMATIC}]
[SQLRULES {DB2 | STD}]
[SYNCPOINT {ONEPHASE | TWOPHASE | NONE}] [CONNECT_MEMBER
{N | CATALOG_MEMBER}][ATTACH_MEMBER N]

SET RUNTIME DEGREE

SET RUNTIME DEGREE FOR { ALL | ( ANWENDUNGS-ID
[{, ANWENDUNGS-ID} ...] ) } TO GRAD

SET TABLESPACE CONTAINERS

SET TABLESPACE CONTAINERS FOR TABBEREICH-ID
[{REPLAY | IGNORE} ROLLFORWARD CONTAINER OPERATIONS]
USING {AUTOMATIC STORAGE | ( {PATH 'CONTAINERZEICHENFOLGE' [{, PATH 'CONTAINERZEICHENFOLGE'}...] |
{FILE | DEVICE} 'CONTAINERZEICHENFOLGE' SEITENANZAHL
[{, {FILE | DEVICE} 'CONTAINERZEICHENFOLGE' SEITENANZAHL}...]}} )

SET TAPE POSITION

SET TAPE POSITION [ON ] TO
IST EIN GüLTIGER BANDEINHEITENNAME
DER STANDARD BEI WINDOWS NT IST \\.\TAPE0
IST DIE BANDMARKE, AUF DIE DAS BAND POSITIONIERT WERDEN MUSS
1 = ERSTE POSITION, 2 = ZWEITE POSITION ETC.

SET UTIL_IMPACT_PRIORITY

SET UTIL_IMPACT_PRIORITY FOR TO

SET WRITE

SET WRITE RESUME FOR DATABASE

SET WRITE SUSPEND FOR DATABASE [ INCLUDE LOGS | EXCLUDE LOGS ]

START DATABASE MANAGER

{START DATABASE MANAGER | DB2START} [REMOTE [INSTANCE] INSTANZNAME
{ADMINNODE KNOTENNAME | HOSTNAME HOSTNAME} USER BENUTZERNAME USING KENNWORT]
[ADMIN MODE {USER BENUTZERNAME | GROUP GUPPENNAME }] [PROFILE PROFIL] [INSTANCE ON HOSTNAME]
[[DBPARTITIONNUM | MEMBER | CF] DATENBANKPARTITIONSNUMMER] [ADD DBPARTITIONNUM HOSTNAME HOSTNAME
HOSTNAME HOSTNAME PORT LOGISCHER-PORT [COMPUTER COMPUTERNAME] [USER BENUTZERNAME]
[PASSWORD KENNWORT] [NETNAME NETZNAME] [LIKE DBPARTITIONNUM DATENBANKPARTITIONSNUMMER |
WITHOUT TABLESPACES]] | STANDALONE | RESTART [HOSTNAME HOSTNAME]
[PORT LOGISCHER-PORT] [COMPUTER COMPUTERNAME] [USER BENUTZERNAME] [PASSWORD KENNWORT]
[NETNAME NETZNAME] ] ]

START HADR

START HADR ON DATABASE ALIASNAME-DER-DATENBANK [USER BENUTZERNAME [USING KENNWORT]] AS
{PRIMARY [BY FORCE] | STANDBY}

STOP DATABASE MANAGER

{STOP DATABASE MANAGER | DB2STOP} [REMOTE [INSTANCE] INSTANZNAME
{ADMINNODE KNOTENNAME | HOSTNAME HOSTNAME} USER BENUTZERNAME USING KENNWORT] [INSTANCE ON HOSTNAME [FORCE]]
[PROFILE PROFIL] [[DBPARTITIONNUM | MEMBER | CF] DATENBANKPARTITIONSNUMMER | DROP DBPARTITIONNUM
DATENBANKPARTITIONSNUMMER | FORCE [[DBPARTITIONNUM | MEMBER | CF] DATENBANKPARTITIONSNUMMER] | QUIESCE [MINUTEN]]

STOP HADR

STOP HADR ON DATABASE ALIASNAME-DER-DATENBANK [USER BENUTZERNAME [USING KENNWORT]]

TAKEOVER HADR

TAKEOVER HADR ON DATABASE ALIASNAME-DER-DATENBANK [USER BENUTZERNAME [USING KENNWORT]]
[BY FORCE [PEER WINDOW ONLY]]

TERMINATE

TERMINATE

UNCATALOG DATABASE

UNCATALOG DATABASE ALIASNAME-DER-DATENBANK

UNCATALOG DCS DATABASE

UNCATALOG DCS DATABASE DATENBANKNAME

UNCATALOG LDAP DATABASE

UNCATALOG LDAP DATABASE ALIASNAME-DER-DATENBANK
[USER BENUTZER [PASSWORD KENNWORT]]

UNCATALOG LDAP NODE

UNCATALOG LDAP NODE KNOTENNAME
[USER BENUTZER [PASSWORD KENNWORT]]

UNCATALOG NODE

UNCATALOG NODE KNOTENNAME

UNCATALOG ODBC DATA

UNCATALOG [USER | SYSTEM] ODBC DATA SOURCE NAME-DER-DATENQUELLE

UNQUIESCE DATABASE

UNQUIESCE DATABASE

UNQUIESCE INSTANCE

UNQUIESCE INSTANCE INSTANZNAME

UPDATE ADMIN CFG

UPDATE ADMIN CONFIGURATION USING {KONFIGURATIONSSCHLüSSEL ...}
[FOR NODE KNOTENNAME [USER BENUTZERNAME USING KENNWORT]]

KONFIGURATIONSSCHLüSSEL:
AUTHENTICATION, CONTACT_HOST, DASADM_GROUP, DAS_CODEPAGE, DAS_TERRITORY,
DB2SYSTEM, DISCOVER, EXEC_EXP_TASK, JDK_PATH, JDK_64_PATH, SCHED_ENABLE,
SMTP_SERVER, TOOLSCAT_DB, TOOLSCAT_INST, TOOLSCAT_SCHEMA

UPDATE CLI CFG

UPDATE CLI CONFIGURATION [AT {USER | GLOBAL} LEVEL] FOR SECTION ABSCHNITTNAME
USING {CLI-SCHLüSSELWORTWERT ...}

UPDATE DB CFG

UPDATE DATABASE CONFIGURATION [FOR ALIASNAME-DER-DATENBANK] [MEMBER MEMBERNUMMER]
USING {KONFIGURATIONSSCHLüSSEL ...} [IMMEDIATE | DEFERRED]

KONFIGURATIONSSCHLüSSEL:
ALT_COLLATE, APPLHEAPSZ, APPL_MEMORY, ARCHRETRYDELAY, AUTORESTART, AUTO_REVAL,
AUTO_DB_BACKUP, AUTO_DEL_REC_OBJ, AUTO_MAINT, AUTO_PROF_UPD, AUTO_REORG,
AUTO_RUNSTATS, AUTO_STATS_PROF, AUTO_SAMPLING, AUTO_STATS_VIEWS,
AUTO_STMT_STATS, AUTO_TBL_MAINT, AVG_APPLS, BLK_LOG_DISK_FUL, BLOCKNONLOGGED,
BUFFPAGE, CATALOGCACHE_SZ, CHNGPGS_THRESH, COPYPROTECT, CUR_COMMIT,
DATABASE_MEMORY, DBHEAP, DB_MEM_THRESH, DECFLT_ROUNDING, DFT_DEGREE,
DFT_EXTENT_SZ, DFT_LOADREC_SES, DFT_MTTB_TYPES, DFT_PREFETCH_SZ, DFT_QUERYOPT,
DFT_REFRESH_AGE, DFT_SQLMATHWARN, DIR_OBJ_NAME, DISCOVER_DB, DLCHKTIME,
DYN_QUERY_MGMT, ENABLE_XMLCHAR, FAILARCHPATH, HADR_LOCAL_HOST,
HADR_LOCAL_SVC, HADR_PEER_WINDOW, HADR_REMOTE_HOST, HADR_REMOTE_INST,
HADR_REMOTE_SVC, HADR_SYNCMODE, HADR_TIMEOUT, INDEXREC, INDEXSORT, LOCKLIST,
LOCKTIMEOUT, LOGARCHMETH1, LOGARCHMETH2, LOGARCHCOMPR1, LOGARCHCOMPR2,
LOGARCHOPT1, LOGARCHOPT2, LOGBUFSZ, LOGFILSIZ, LOGINDEXBUILD, LOGPRIMARY,
LOGSECOND, MAXAPPLS, MAXFILOP, MAXLOCKS, MAX_LOG, MINCOMMIT, MIRRORLOGPATH,
MULTIPAGE_ALLOC, NEWLOGPATH, NUMARCHRETRY, NUM_DB_BACKUP, NUM_FREQVALUES,
NUM_IOCLEANERS, NUM_IOSERVERS, NUM_LOG_SPAN, NUM_QUANTILES, OVERFLOWLOGPATH,
PAGESIZE, PCKCACHESZ, REC_HIS_RETENTN, RESTRICT_ACCESS, SELF_TUNING_MEM,
SEQDETECT, SHEAPTHRES_SHR, SMTP_SERVER, SOFTMAX, SORTHEAP, SQL_CCFLAGS,
STAT_HEAP_SZ, STMT_CONC, STMTHEAP, TRACKMOD, TSM_MGMTCLASS, TSM_NODENAME,
TSM_OWNER, TSM_PASSWORD, UTIL_HEAP_SZ, VENDOROPT, WLM_COLLECT_INT,
MON_REQ_METRICS, MON_ACT_METRICS, MON_OBJ_METRICS, CF_DB_MEM_SZ, CF_GBP_SZ,
CF_SCA_SZ, CF_LOCK_SZ, CF_CATCHUP_TRGT. MON_UOW_DATA, MON_LOCKTIMEOUT,
MON_DEADLOCK, MON_LOCKWAIT, MON_LW_THRESH, MON_PKGLIST_SZ, MON_LCK_MSG_LVL,
SECTION_ACTUALS, CONNECT_PROC, SYSTIME_PERIOD_ADJ, MON_UOW_PKGLIST,
MON_UOW_EXECLIST, LOG_DDL_STMTS, LOG_APPL_INFO, MON_RTN_EXECLIST,
CF_DEDA_RATIO, DFT_SCHEMAS_DCC,HADR_SPOOL_LIMIT, HADR_TARGET_LIST,
HADR_REPLAY_DELAY, MON_RTN_DATA, DFT_TABLE_ORG, STRING_UNITS,
NCHAR_MAPPING, TIER2_BP_PATH, TIER2_BP_SIZE, EXTENDED_ROW_SZ,
OPT_DIRECT_WRKLD, PAGE_AGE_TRGT_MCR, PAGE_AGE_TRGT_GCR, CF_TRANSPORT_METHOD

UPDATE DBM CFG

UPDATE DATABASE MANAGER CONFIGURATION [MEMBER MEMBERNUMMER]
USING {KONFIGURATIONSSCHLüSSEL ...} [IMMEDIATE | DEFERRED]

KONFIGURATIONSSCHLüSSEL:
AGENTPRI, AGENT_STACK_SZ, ALTERNATE_AUTH_ENC, ALT_DIAGPATH, ASLHEAPSZ,
AUDIT_BUF_SZ, AUTHENTICATION, CATALOG_NOAUTH, CLNT_KRB_PLUGIN, CLNT_PW_PLUGIN,
COMM_BANDWIDTH, CONN_ELAPSE, CPUSPEED, DATAFLOWENCRYPT, DFTDBPATH,
DFT_ACCOUNT_STR, DFT_MON_BUFPOOL, DFT_MON_LOCK, DFT_MON_SORT, DFT_MON_STMT,
DFT_MON_TABLE, DFT_MON_UOW, DIAGLEVEL, DIAGPATH, DIAGSIZE, DIR_CACHE,
DISCOVER, DISCOVER_COMM, DISCOVER_INST, FCM_NUM_BUFFERS, FCM_NUM_CHANNELS,
FCM_PARALLELISM, FEDERATED, FEDERATED_ASYNC, FED_NOAUTH, FENCED_POOL,
GROUP_PLUGIN, HEALTH_MON, INDEXREC, INSTANCE_MEMORY, INTRA_PARALLEL,
JAVA_HEAP_SZ, JDK_PATH, KEEPFENCED, LOCAL_GSS_PLUGIN, MAXAGENTS,
MAXCAGENTS, MAX_CONNECTIONS, MAX_CONNRETRIES, MAX_COORDAGENTS,
MAX_LOGICAGENTS, MAX_QUERYDEGREE, MAX_TIME_DIFF, MON_HEAP_SZ,
NOTIFYLEVEL, NUMDB, NUM_INITAGENTS, NUM_INITFENCED, NUM_POOLAGENTS,
RQRIOBLK, RSTRT_LIGHT_MEM, SHEAPTHRES, SPM_LOG_PATH, SPM_LOG_SIZE,
SPM_MAX_RESYNC, SPM_NAME, SSL_CIPHERSPECS, SSL_CLNT_KEYDB, SSL_CLNT_STASH,
SSL_SVCENAME, SSL_SVR_KEYDB, SSL_SVR_LABEL, SSL_SVR_STASH, SSL_VERSIONS,
START_STOP_TIME, SVCENAME, SVRCON_AUTH, SVRCON_GSSPLUGIN_LIST,
SVRCON_PW_PLUGIN, SVR_PLUGIN_MODE, SYSADM_GROUP, SYSCTRL_GROUP,
SYSMAINT_GROUP, SYSMON_GROUP, TM_DATABASE, TP_MON_NAME, TRUST_ALLCLNTS,
TRUST_CLNTAUTH, UTIL_IMPACT_LIM, CF_MEM_SZ, CF_NUM_WORKERS, CF_DIAGPATH,
CF_DIAGLEVEL, CF_NUM_CONNS, WLM_DISPATCHER, WLM_DISP_CONCUR,
WLM_DISP_CPU_SHARES, WLM_DISP_MIN_UTIL, COMM_EXIT_LIST.

UPDATE ALERT CFG

UPDATE ALERT CONFIGURATION FOR {{CONTAINERS | DATABASE MANAGER | DATABASES |
TABLESPACES} | {CONTAINER CONTAINERNAME FOR TABBEREICHSNAME | DATABASE |
TABLESPACE TABBEREICHSNAME} ON ALIASNAME-DER-DATENBANK} USING NAME-DES-DIAGNOSEANZEIGERS
{SET PARAMETERNAME WERT [ {,PARAMETERNAME WERT} ... ] | UPDATE ACTION
{SCRIPT PFADNAME | TASK TASKNAME} ON {ALARM | ALLALERT | ATTENTION STATUS | WARNING}
SET PARAMETERNAME WERT [ {,PARAMETERNAME WERT} ... ] [ {,{SCRIPT PFADNAME |
TASK TASKNAME} ON {ALARM | ALLALERT | ATTENTION STATUS | WARNING} SET PARAMETERNAME WERT
[ {,PARAMETERNAME WERT} ... ]} ... ] | DELETE ACTION {SCRIPT PFADNAME |
TASK TASKNAME} ON {ALARM | ALLALERT | ATTENTION STATUS | WARNING} [ {,{SCRIPT PFADNAME |
TASK TASKNAME} ON {ALARM | ALLALERT | ATTENTION STATUS | WARNING}} ... ]
ADD ACTION {SCRIPT PFADNAME HINZUFüGESCRIPTDETAILS | TASK TASKNAME} ON {ALARM | ALLALERT |
ATTENTION STATUS | WARNING} [ {,{SCRIPT PFADNAME HINZUFüGESCRIPTDETAILS |
TASK TASKNAME} ON {ALARM | ALLALERT | ATTENTION STATUS | WARNING}} ... ] [ON HOSTNAME]
USER BENUTZERNAME USING KENNWORT}

HINZUFüGESCRIPTDETAILS:
TYPE {DB2 [STATEMENT TERMINATION CHARACTER ZEICHEN] | OPERATING SYSTEM
[COMMAND LINE PARAMETERS PARAMETER]} WORKING DIRECTORY PFADNAME

UPDATE COMMAND OPTIONS

UPDATE COMMAND OPTIONS USING {OPTIONEN ...}

OPTIONEN:
A {ON|OFF} SQLCA ANZEIGEN
B {ON|OFF} AUTOMATISCH BINDEN
C {ON|OFF} AUTOMATISCHES COMMIT
D {ON|OFF} XML-DEKLARATIONEN ABRUFEN UND ANZEIGEN
E {ON {C|S} | OFF} SQLCODE/SQLSTATE ANZEIGEN
I {ON|OFF} XML-DATEN MIT EINRüCKUNG ANZEIGEN
L {ON DATEINAME | OFF} BEFEHLE PROTOKOLLIEREN
M {ON|OFF} ANZAHL BETROFFENER ZEILEN ANZEIGEN
N {ON|OFF} ZEILENVORSCHUBZEICHEN ENTFERNEN
O {ON|OFF} AUSGABE ANZEIGEN
P {ON|OFF} DB2-EINGABEAUFFORDERUNG ANZEIGEN
Q {ON|OFF} LEERZEICHEN UND ZEILENVORSCHüBE BEIBEHALTEN
R {ON DATEINAME | OFF} AUSGABEBERICHT IN DATEI SPEICHERN
S {ON|OFF} BEI FEHLER BEFEHLSAUSFüHRUNG STOPPEN
V {ON|OFF} AKTUELLEN BEFEHL ZURüCKMELDEN
W {ON|OFF} WARNUNGEN FüR FETCH/SELECT ANZEIGEN
X {ON|OFF} DRUCKEN VON SPALTENüBERSCHRIFTEN UNTERDRüCKEN
Z {ON DATEINAME | OFF} GESAMTE AUSGABE IN DATEI SPEICHERN

UPDATE CONTACT

UPDATE CONTACT NAME-DES-ANSPRECHPARTNERS USING SCHLüSSELWORTWERT [ {, SCHLüSSELWORTWERT} ... ]

UPDATE CONTACTGROUP

UPDATE CONTACTGROUP NAME-DER-ANSPRECHPARTNERGRUPPE {ADD | DROP} {CONTACT | GROUP} NAME
[ {,{ADD | DROP} {CONTACT | GROUP} NAME} ... ] [DESCRIPTION NEUE-BESCHREIBUNG]

UPDATE HISTORY

UPDATE HISTORY {FOR OBJEKTTEIL | EID EID} WITH {LOCATION NEUE-SPEICHERPOSITION
DEVICE TYPE NEUER-EINHEITENTYP | COMMENT NEUER-KOMMENTAR | STATUS NEUER-STATUS}

NEUER-EINHEITENTYP:
(P)LATTE, DIS(K)ETTE, (B)AND, (A)DSM, B(E)NUTZERAUSGANG, (S)ONSTIGE

UPDATE LDAP NODE

UPDATE LDAP NODE KNOTENNAME
[HOSTNAME HOSTNAME] [SVCENAME SERVICENAME] |
[NNAME SERVERNNAME] |
[IPX_ADDRESS IPX-ADRESSE] |
[NETWORK NETZ-ID] [PARTNERLU PARTNER-LU] [MODE MODUS]
[TPNAME TP-NAME] [SECURITY {NONE | SAME | PROGRAM}]
[LANADDRESS LAN-ADAPTERADRESSE] [CHGPWDLU KENNWORTäNDERUNGS-LU]
[WITH "KOMMENTARZEICHENFOLGE"] [USER BENUTZER [PASSWORD KENNWORT]]

UPDATE MONITOR SWITCHES

UPDATE MONITOR SWITCHES USING {SCHALTERNAME {ON | OFF} ...}
[AT MEMBER MEMBERNUMMER | GLOBAL]

SCHALTERNAME:
BUFFERPOOL, LOCK, SORT, STATEMENT, TABLE, TIMESTAMP, UOW

UPDATE NOTIFICATION LIST

UPDATE {HEALTH NOTIFICATION CONTACT | NOTIFICATION} LIST {ADD | DROP}
{CONTACT | GROUP} NAME [ {,{ADD | DROP} {CONTACT | GROUP} NAME} ... ]

UPGRADE DATABASE

UPGRADE DATABASE ALIASNAME-DER-DATENBANK [USER BENUTZERNAME [USING KENNWORT]] [REBINDALL]

XQUERY

XQUERY XQUERY-ANWEISUNG