IDMSRADM › General Usage

General Usage

Input

Input to IDMSRADM consists of:

• The database or sequential file containing the objects to be processed
• Statements to control the utility processing

Output

The IDMSRADM utility generates a message listing that reports on the objects processed.

In addition, depending on the operation performed, IDMSRADM may change the contents of:

• The sequential file containing the processed objects
• The database
• The catalog segment of the dictionary

Function Exclusivity

IDMSRADM functions are exclusive. You cannot mix IMPORT, EXPORT, DELETE, or REPORT on the same IDMSRADM run.

Execution Mode

You can execute the IDMSRADM utility in local mode or under central version.

Sample output

Below is a sample Space Utilization report:

mm/dd/yy 11:08:42             IDMSRADM              - CA/ICMS DATABASE ADMINISTRATION UTILITY                         PAGE:     1
SIGNON USER "CULL DBA" PASSWORD ??????? DBNAME ASFDICT .
PROCESS SEGMENT ASFDICT .
REPORT ALL DETAIL  .
BYE .
mm/dd/yy 11:08:42             IDMSRADM              - CA/ICMS DATABASE ADMINISTRATION UTILITY                         PAGE:     2
                                                      SPACE UTILIZATION BY USER
                                                    DMCL: CVDMCL       ALL  DETAIL
USER NAME                            OBJECT   TABLE
   OBJECT NAME                        TYPE    NUMBER    SEGMENT         AREA                             SPACE USED
CULL DBA
   DEMO                             DATATABLE    107    ASFDICT     IDMSR-AREA2                                 224
   USER LIMIT:              NONE    USER TOTALS:                                                                224
mm/dd/yy 11:08:42             IDMSRADM              - CA/ICMS DATABASE ADMINISTRATION UTILITY                         PAGE:     3
                                                      SPACE UTILIZATION BY USER
                                                    DMCL: CVDMCL       ALL  DETAIL
USER NAME                            OBJECT   TABLE
   OBJECT NAME                        TYPE    NUMBER    SEGMENT         AREA                             SPACE USED
JPD
   MYTAB                            DATATABLE    115    ASFDICT     IDMSR-AREA2                                  56
   USER LIMIT:              NONE    USER TOTALS:                                                                 56
mm/dd/yy 11:08:42             IDMSRADM              - CA/ICMS DATABASE ADMINISTRATION UTILITY                         PAGE:     4
                                                      SPACE UTILIZATION BY USER
                                                    DMCL: CVDMCL       ALL  DETAIL
USER NAME                            OBJECT   TABLE
   OBJECT NAME                        TYPE    NUMBER    SEGMENT         AREA                             SPACE USED
USER1
   DATATYP                          DATATABLE    112    ASFDICT     IDMSR-AREA2                                 312
   GENTAB2                          DATATABLE    114    ASFDICT     IDMSR-AREA2                                  56
   GENTEST                          DATATABLE    111    ASFDICT     IDMSR-AREA2                                  56
   STAMPTST                         DATATABLE    113    ASFDICT     IDMSR-AREA2                                 192
   TABLE1                           DATATABLE    101    ASFDICT     IDMSR-AREA2                                 896
   TESTTAB-103                      DATATABLE    106    ASFDICT     IDMSR-AREA2                               1,232
   TEST2                            DATATABLE    105    ASFDICT     IDMSR-AREA2                                 388
   TEST8                            DATATABLE    110    ASFDICT     IDMSR-AREA2                                  56
   USER LIMIT:               300    USER TOTALS:                                                              3,188
mm/dd/yy 11:08:42             IDMSRADM              - CA/ICMS DATABASE ADMINISTRATION UTILITY                         PAGE:     5
                                                      SPACE UTILIZATION BY USER
                                                    DMCL: CVDMCL       ALL  DETAIL
USER NAME                            OBJECT   TABLE
   OBJECT NAME                        TYPE    NUMBER    SEGMENT         AREA                             SPACE USED
   TOTALS FOR THIS REPORT .........................                                                           3,468
mm/dd/yy 11:08:42             IDMSRADM              - CA/ICMS DATABASE ADMINISTRATION UTILITY                         PAGE:     6

*** END OF JOB ***