The Database Administrator Language DAL for UDS-D

The following DAL commands, which are important for UDS-D, are processed by the independent DBH.

All DAL commands that are only known to UDS-D begin with the special character “&”. These DAL commands (except for &START DISTRIBUTION) are rejected if UDS-D mode has not been started. Detailed descriptions of the “&” DAL commands can be found in the section describing the other UDS-D DAL commands in alphabetical order.

DAL command	Meaning
ABORT {transaction-id[,OPTION=PTC] |         ALL}	Roll back the specified open transactions If OPTION=PTC is specified: without taking cross-configuration consistency or UDS/SQL and openUTM consistency into account
&ADD DISTRIBUTION,     {NODE=processor-name,           CONF=confname[,DB=dbname] |     DB=dbname,SS=subschema-name |     FILE=file-name }	Add new entries to the distribution table
&CHANGE DISTRIBUTION,    NODE=processor-name,    CONF=confname	Assign a configuration to another host
&CLOSE DISTRIBUTION	End UDS-D mode
COMMIT transaction-id	Terminate transaction in PTC state by committing updates (FINISH) without taking cross-configuration consistency or UDS/SQL and openUTM consistency into account
&DISPLAY DISTRIBUTION    [,NODE=processor-name]    [,CONF=confname]    [,DB=dbname]    [,SS=subschema-name]	Display distribution table
&DROP DISTRIBUTION,      {ALL |     NODE=processor-name,        CONF=confname[,DB=dbname][,ALL] |     DB=dbname,SS=subschema-name }	Delete entries in the distribution table
&LOCK DISTRIBUTION,     {NODE=processor-name |      CONF=confname |      DB=dbname |      SS=subschema-name }	Lock entries in distribution table
MODIFY PTCSYNCH,     VALUE=([{WAIT | ABORT | COMMIT}]            [,[{WAIT | ABORT | COMMIT}]])	Modify value of the DBH load parameter PTCSYNCH
&PWD DISTRIBUTION,CONF=confname,     {PWN=new-password |      PWO=old-password|      PWO=old-password,PWN=new-password}	Assign and modify password
&SAVE DISTRIBUTION,FILE=filename	Save distribution table
&START DISTRIBUTION	UDS-D mode starten
&SYNCHRONIZE DISTRIBUTION	Terminate secondary subtransactions in PTC state
&UNLOCK DISTRIBUTION,    {NODE=processor-name |    CONF=confname |    DB=dbname |    SS=subschema-name }	Unlock entries in the distribution table

Table 34: DAL commands for UDS-D

The DAL commands are described in detail in section “The Database Administrator Language DAL”.