The pdrdrefls command displays information about related RDAREAs.

The pdrdrefls command has the following two functions:

1. Displaying information about related RDAREAs
2. Checking the relationships among RDAREAs

HiRDB administrator

(a) Displaying information about related RDAREAs

 
  pdrdrefls [-k dsp] -e org
 
            {-r RDAREA-name[,RDAREA-name]...|-r ALL
 
            |-t [authorization-identifier.]table-identifier}
 
            [-s server-name[,server-name]...] [-l [-d delimiter]] [-a][-c constraint-type]
 

(b) Checking the relations among RDAREAs

 
  pdrdrefls -k chk -e org {-r RDAREA-name[,RDAREA-name]...|-r ALL}
 
           [-s server-name[,server-name]...][-c constraint-type]
 

(a) -k {dsp|chk}

Specifies the function of the pdrdrefls command that is to be executed.

dsp:

Display information about all RDAREAs that store a specified table or all RDAREAs that are related to a specified resource (table, index, LOB column).

chk:

Check the relationships among RDAREAs. If related RDAREAs are missing, this option displays a message providing information about the missing RDAREAs.

(b) -e org

This option is fixed.

(c) -r original-RDAREA-name[,original-RDAREA-name]... ~<identifier> ((1-30))

Specifies the names of the RDAREAs to be processed. If you use updatable online reorganization, specify the name of the original RDAREA. Note that only user RDAREAs (excluding temporary table RDAREAs) and user LOB RDAREAs can be specified.

For the rules for specifying RDAREAs, see 1.5.2 Specification of RDAREAs in operation commands and utilities.

(d) -r ALL

Specifies that all user RDAREAs (excluding temporary table RDAREAs) and user LOB RDAREAs are to be processed.

(e) -t [authorization-identifier.]table-identifier} ~<identifier> ((authorization identifier: 1 to 30, table identifier: 1 to 30))

Specifies the name of a table to be processed.

When the authorization identifier is omitted, the command assumes the authorization identifier set in the PDUSER environment variable at the time of command execution. If the PDUSER environment variable has not been set or simple authentication keywords are specified in both the authorization identifier and the password in the PDUSER environment variable^#, the command assumes the user name specified in the logon window. The following table shows the authorization identifier that takes effect depending on the specification of the -t option and the PDUSER environment variable:

#

The PDUSER environment variable setting is used regardless of whether the facility for simple authentication of OS login users is enabled (pd_os_authenticate operand value in the system common definition). For details about simple authentication keywords, see Facility for simple authentication of OS login users in the HiRDB Version 9 System Operation Guide.

If the authorization identifier and table identifier are enclosed between double quotation marks ("), they are treated as being case sensitive; otherwise, they are treated as being in all uppercase letters. If you are using sh (Bourne shell), csh (C shell), or ksh (Korn shell), you must enclose the entire identifier between single quotation marks (').

(f) -s server-name[,server-name]... ~<identifier> ((1-8))

Specifies the names of servers to be processed. You can specify a maximum of 128 server names.

When -k dsp is specified, the command displays only information that has been defined in the specified servers.

When -k chk is specified, the command checks to see whether all the RDAREAs specified in the -r option have been defined in the specified servers. If any of the RDAREAs specified in the -r option does not satisfy this condition, the command displays the applicable RDAREA name in a message and then terminates with an error.

You can check the server names to be specified using pddbst's condition analysis in units of RDAREAs (logical analysis) or in units of tables.

(g) -l

Specifies that the output information is to be displayed without line breaks.

(h) -d delimiter

Specifies a single-byte character as the delimiter for the information that is output when the -l option is specified.

When this option is omitted, the command assumes a space.

To specify a special character as the delimiter, such as a single quotation mark (') or double quotation mark ("), specify \' or \". To specify the escape character as the delimiter, specify \\.

(i) -a

Specifies that all related information (server names, RDAREA names, RDAREA types, and resource information) is to be displayed. When this option is omitted, the command display only the RDAREA names.

(j) -c constraint-type

Specifies that referential RDAREA information associated with referential constraints is to be displayed or checked.

ref

Specifies that the RDAREA information associated with referential constraints is to be displayed or checked. An RDAREA associated with referential constraints is an RDAREA that stores a referencing table or referenced table and that must be handled with the generation number. For details about how to handle referential constraints, see the manual HiRDB Version 9 Installation and Design Guide.

1. The pdrdrefls command can be executed only while HiRDB is active.
2. The pdrdrefls command must be executed at the server machine that contains the single server or where the system manager is located.

1. The result of the pdrdrefls command can be checked on the basis of the return code from execution of the command. Return code 0 for the pdrdrefls command indicates normal termination, return code 4 indicates warning termination (there is no resource to be analyzed), and return code 8 indicates abnormal termination.
2. Do not add to, delete, or change the definition of a table or index for an RDAREA that is to be processed by the pdrdrefls command. If you do so, the command's execution result may be invalid or the command may terminate abnormally.
3. If you use updatable online reorganization and use the pdrdrefls command to obtain information about a related RDAREA to use it as input information for a command or a utility, make sure that once information about the RDAREA has been obtained you do not rename that RDAREA before you execute the command or utility. If you rename the RDAREA, the command or utility might result in an error because the specified RDAREA could not be found. In such a case, specify the new RDAREA name in the command or utility and then re-execute.

Explanation

server-name (maximum of 8 bytes):

Name of a server that contains related RDAREAs.

RDAREA-name (maximum of 32 bytes):

Name of a related RDAREA. The RDAREA name is enclosed in double quotation marks (").

RDAREA-type (maximum of 8 bytes):

Type of RDAREA:

USER: User RDAREA

USER_LOB: User LOB RDAREA

resource-type (3 bytes):

Type of resource:

TBL: Table

IDX: Index

LOB: LOB column

resource-name (maximum of 65 bytes):

Name of the resource that is stored in the corresponding RDAREA. The resource name is enclosed in double quotation marks.

When the resource type is TBL: authorization-identifier.table-identifier

When the resource type is IDX: authorization-identifier.index-identifier

When the resource type is LOB: LOB column name or abstract data type column name of LOB attribute

name-of-related-resource (maximum of 67 bytes):

Name of the resource related to the resource with type IDX or LOB. The related resource name is displayed in the format authorization-identifier.table-identifier and is enclosed in double quotation marks.

name-of-resource-associated-by-constraint (maximum of 69 bytes):

Name of the resource with type TBL that is associated by the constraint definition. This information is displayed only when the -c option is specified. When -c ref is specified, the name of the referenced table is displayed. A constraint-associated resource name is displayed enclosed in double quotation marks (").

This example displays information about related RDAREAs when updatable online reorganization is used. The example omits the -d option. In the execution result, indicates a single-byte space.

• RDAREA configuration
  

  

• Execution result

• When pdrdrefls -e org -r RD01 -a is specified
  

   
  SERVER NAME : BES1
    RDAREA NAME : "RD01"
    AREA TYPE : USER
      RESOURCE  : TBL : "user1"."TBL1"
                        "user2"."TBL2"
                        "user1"."TBL3"
                  IDX : "user1"."IDX1"
                        ("user1"."TBL1")
                        "user1"."IDX3"
                        ("user1"."TBL3")
    RDAREA NAME : "RD02"
      AREA TYPE : USER
      RESOURCE  : TBL : "user2"."TBL2"
                        "user1"."TBL3"
                  IDX : "user2"."IDX2"
                        ("user2"."TBL2")
                        "user1"."IDX3"
                        ("user1"."TBL3")
    RDAREA NAME : "RD04"                  -
      AREA TYPE : USER                     |
      RESOURCE  : TBL : "user1"."TBL4"     |-#
                        -><"user1"."TBL1"> |
                  IDX : "user1"."IDX4"     |
                       ("user1"."TBL4")   -
    RDAREA NAME : "LOB01"
      AREA TYPE : USER_LOB
      RESOURCE  : LOB : "COL1"
                        ("user1"."TBL1")
   

  #: Displayed only when -c ref is specified.

• When pdrdrefls -e org -r RD01 is specified
  

   
    RDAREA NAME : "RD01"
    RDAREA NAME : "RD02"
    RDAREA NAME : "RD04" #
    RDAREA NAME : "LOB01"
   

  #: Displayed only when -c ref is specified.

• When pdrdrefls -e org -r RD01 -l -a is specified
  

   
  BES1"RD01"USERTBL"user1"."TBL1"
  BES1"RD01"USERTBL"user2"."TBL2"
  BES1"RD01"USERTBL"user1"."TBL3"
  BES1"RD01"USERIDX"user1"."IDX1""user1"."TBL1"
  BES1"RD01"USERIDX"user1"."IDX3""user1"."TBL3"
  BES1"LOB01"USER_LOBLOB"COL1""user1"."TBL1"
  BES1"RD02"USERTBL"user2"."TBL2"
  BES1"RD02"USERTBL"user1"."TBL3"
  BES1"RD02"USERIDX"user2"."IDX2""user2"."TBL2"
  BES1"RD02"USERIDX"user1"."IDX3""user1"."TBL3"
  BES1"RD04"USERTBL"user1"."TBL4"
  "user1"."TBL1" #
  BES1"RD04"USERIDX"user1"."IDX4"
  "user1"."TBL4" #
   

  #: Displayed only when -c ref is specified.

• When pdrdrefls -e org -r RD01 -l is specified
  

   
  "RD01""RD02""LOB01""RD04" #
   

  #: Displayed only when -c ref is specified.

• When pdrdrefls -e org -r RD02 -a is specified
  

   
  SERVER NAME : BES1
    RDAREA NAME : "RD02"
      AREA TYPE : USER
      RESOURCE  : TBL : "user2"."TBL2"
                        "user1"."TBL3"
                  IDX : "user2"."IDX2"
                        ("user2"."TBL2")
                        "user1"."IDX3"
                        ("user1"."TBL3")
    RDAREA NAME : "RD01"
      AREA TYPE : USER
      RESOURCE  : TBL : "user1"."TBL1"
                        "user2"."TBL2"
                        "user1"."TBL3"
                  IDX : "user1"."IDX1"
                        ("user1"."TBL1")
                        "user1"."IDX3"
                        ("user1"."TBL3")
    RDAREA NAME : "RD04"                  -
      AREA TYPE : USER                     |
      RESOURCE  : TBL : "user1"."TBL4"     |-#
                        -><"user1"."TBL1"> |
                  IDX : "user1"."IDX4"     |
                       ("user1"."TBL4")   -
    RDAREA NAME : "LOB01"
      AREA TYPE : USER_LOB
      RESOURCE  : LOB : "COL1"
                        ("user1"."TBL1")
   

  #: Displayed only when -c ref is specified.

• When pdrdrefls -e org -r RD03 -a is specified
  

   
  SERVER NAME : BES2
    RDAREA NAME : "RD03"
      AREA TYPE : USER
      RESOURCE  : TBL : "user1"."TBL3
                  IDX : "user1"."IDX3"
                        ("user1"."TBL3")

• When pdrdrefls -e org -r RD04 -a is specified
  

   
  SERVER NAME : BES1
    RDAREA NAME : "RD04"
      AREA TYPE : USER
      RESOURCE  : TBL : "user1"."TBL4"
                        -><"user1"."TBL1"> #
                  IDX : "user1"."IDX4"
                        ("user1"."TBL4")
    RDAREA NAME : "RD01"                -
      AREA TYPE : USER                   |
      RESOURCE  : TBL : "user1"."TBL1"   |
                        "user2"."TBL2"   |
                        "user1"."TBL3"   |
                  IDX : "user1"."IDX1"   |
                        ("user1"."TBL1") |
                        "user1"."IDX3"   |
                        ("user1"."TBL3") |
    RDAREA NAME : "RD02"                 |-#
      AREA TYPE : USER                   |
      RESOURCE  : TBL : "user2"."TBL2"   |
                        "user1"."TBL3"   |
                  IDX : "user2"."IDX2"   |
                        ("user2"."TBL2") |
                        "user1"."IDX3"   |
                        ("user1"."TBL3") |
    RDAREA NAME : "LOB01"                |
      AREA TYPE : USER_LOB               |
      RESOURCE  : LOB  : "COL1"          |
                  ("user1"."TBL1")      -
   

  #: Displayed only when -c ref is specified.