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
|