Reports › Introduction

Introduction

This section describes and illustrates the nine reports produced by CA IDMS Dictionary Migrator. Each report tracks a different activity performed by CA IDMS Dictionary Migrator. You receive reports with detail and summary results of an extraction, comparisons of the extractions to the object dictionary, parameter input and dictionary verifications, a summary of syntax production difficulties, and a listing of syntax statements produced by CA IDMS Dictionary Migrator.

When reviewing the reports produced by CA IDMS Dictionary Migrator, you should remember the attributes of a successful migration:

Everything needed to recreate an entity in another environment is migrated or accessible.

Introduction of the migrated entities will not adversely affect anything already in the target dictionary.

The CA IDMS Dictionary Migrator reports are descriptions of what is produced after a migration. Each report tracks a different activity. Reports contain descriptions of errors, problems, or anything adversely affected in the target dictionary as well. The following is a table of the CA IDMS Dictionary Migrator reports and their summaries:

CA IDMS Dictionary Migrator Reports

CA IDMS Dictionary Migrator produces nine comprehensive reports:

• Parameter Verification Report
• Source Dictionary Verification Report
• Extract Summary Report
• Extract Detail Report
• Entity Discrepancy Report
• Entity Cross-Reference Report
• Syntax Production Report
• Syntax Files Display Report
• Catalog Navigation Report

From the information in the reports you can preview the migration to check parameter statements, the total number of transactions that will occur during the migration, and the detail of each transaction. You can also use the reports to compare the extracted entities to the object dictionary and review any discrepancies. If any difficulties were encountered in the production of syntax, you can use the reports to identify corrective measures. The reports give you complete control of the migration.

The following pages describe the functions and show samples of CA IDMS Dictionary Migrator reports.

Parameter Verification Report

The Parameter Verification Report displays the parameter statements entered for an execution of CA IDMS Dictionary Migrator after the syntax of the statements has been checked. The statement, as you entered it, is displayed in the right column. If there are errors, they will be marked. Informative, warning, and error messages appear in the left column of the report.

The following report shows a sample Parameter Verification Report.

The Parameter Verification Report contains:

• release number—the version of CA IDMS Dictionary Migrator that was installed, where nn.nn represents the release number and the subrelease number.
• message code—the eight-character code of an informative or error message.
• message text—information that explains the message code.
• parameter statement—display of parameter statement as you have entered it.

  CA TOOLS    RELEASE          CA IDMS/Dictionary Migrator         DATE         TIME         PAGE
              nn.nn          PARAMETER VERIFICATION REPORT       mm/dd/yy    hh:mm:ss       nnnn
                                           V---+----1----+----2----+----3----+----4----+----5----+----6----+----7-V
 NKWP091I INPUT PARAMETER STATEMENT           PROCESS,
 NKWP092I CONTINUATION STATEMENT               IDO=(???????,???????),
 NKWP092I CONTINUATION STATEMENT               IDS=(???????,???????),
 NKWP092I CONTINUATION STATEMENT               OBJD=EMPDEMO,
 NKWP092I CONTINUATION STATEMENT               DISC=(USER,SYNONYM,ATTRIBUTE),
 NKWP092I CONTINUATION STATEMENT               LEVEL=DIALOG,
 NKWP091I CONTINUATION STATEMENT               CHANGEONLY
 NKWP092I CONTINUATION STATEMENT               EXCLTAB=MMOUSE,
 NKWP092I CONTINUATION STATEMENT               EXSOURCE=(MESSAGE),
 NKWP092I CONTINUATION STATEMENT               RUN=VERIFY
 NKWP091I INPUT PARAMETER STATEMENT            EXTRACT,DIALOG=AAX,VERSION=1,LEV
EL=DIALOG
 NKWP094I END OF PARAMETER INPUT
 ──────

Source Dictionary Verification Report

The Source Dictionary Verification Report provides information about the source dictionary after it has been checked for entities. If the entities you requested for an extraction do not appear in the source dictionary, this report shows informative messages about those entities. This report also provides information about referenced entities within processes or maps.

For example, The following report shows a sample Source Dictionary Verification Report that provides messages about components related to other components that are being migrated. The indicated subschema does not have a corresponding load modules in the load area of the dictionary.

The Source Dictionary Verification Report contains:

• entity type—the type of entity referenced within a process or map.
• entity name—the name of the entity referenced within a process or map.
• version number—the version number of the entity referenced within a process or map.
• message code—the eight-character code of an informative or error message.
• message text—information that explains the message code. Detailed information about the message--reasons and appropriate actions--is provided in the chapter "Messages".

The Source Verification report will contain messages related to item 1, finding all of the necessary pieces. If components of an entity cannot be found, or if they appear discrepant with the entity, a message will be produced. The Source Verification Report is formatted as an exception report, only the deficiencies are listed.

Some of the likeliest conditions are:

1. A message is not found. See the chapter "Parameters" for conditions where you might not want to migrate messages. Take into account that by not following the suggestions listed might result in a large number of warning messages produced.
2. A source component has been changed since it was last compiled. This can occur anytime a change is made without a subsequent regeneration. However, it may indicate that a noteworthy change has been made, but not yet compiled.
3. An entity is not found. Depending on the message, this may be an entity named in the parameter's EXTRACT statement or some component of another entity. In either case, it indicates that something that is needed for the migration was not found and will not be migrated, which any cause the migration to be incomplete.

 CA TOOLS    RELEASE          CA IDMS/Dictionary Migrator         DATE         TIME         PAGE
              nn.nn      SOURCE DICTIONARY VERIFICATION REPORT   mm/dd/yy    hh:mm:ss       nnnn
 
  ENTITY-TYPE       ENTITY-NAME      VERSION   ERROR-MESSAGE
 
   LOAD MODULE       STSLRF5              1    ES00505E-INDICATED ENTITY HAD NO RELATED LOAD MODULE
 ──────

Extract Summary and Extract Detail Reports

These reports provide information about the extent of what will be migrated. The Extract Detail Report lists every entity which is related to the entity(s) named in the Extract statement(s). This is known as the "Extract Set." For each entity, its status for the migration listed:

• New (additions)
• Changed (modified)
• Dropped (not migrated)

An entity is dropped when it is presumed to be the same in the source dictionary.

The Extract Summary Report gives totals by entity type and utility.

The Extract Detail Report provides information about each entity that will be extracted from the source dictionary and entities for which delete syntax is created.

Extract Summary Report

The Extract Summary Report provides information about the total number of transactions that will take place for the upload to the CA IDMS utilities and compilers. You can use this report before an actual migration to plan for dictionary space.

The following report shows a sample Extract Summary Report. The report contains:

• CA IDMS utility or compiler name
• transaction type—the type of transaction that occurred for the utility or compiler.
• transaction total—the number of transactions for each utility or compiler.
• transaction type total—the number of transactions for each transaction type.
• change summary—indicates the number of add, change (modify), and drop (not migrated) transactions.

 CA TOOLS   RELEASE    CA IDMS/Dictionary Migrator    DATE        TIME        PAGE
            nn.nn         EXTRACT SUMMARY REPORT      mm/dd/yy    hh:mm:ss    nnnn
                                                   ---- CHANGE     SUMMARY -----
    EXTRACTION CATEGORIES                TOTAL            ADDS   CHANGES     DROPS
    IDMSDDDL TRANSACTIONS                 522               0         0         0
      MESSAGE DELETES                       0               0         0         0
      DICTIONARY LOAD DELETES               7               0         0         0
      DIALOG DELETES                        1               0         0         0
      PROGRAM DELETES                       0               0         0         0
      SCHEMA DELETES                        1               1         0         0
      TABLE DELETES                         0               0         0         0
      QFILE DELETES                         0               0         0         0
      PROCESS DELETES                       5               0         0         0
      MODULE DELETES                        0               0         0         0
      PGROUP DELETES                        0               0         0         0
      RECORD DELETES                       20               0         0         0
      REPORT DELETES                        0               0         0         0
      TRANSACTION DELETES                   0               0         0         0
      FILE DELETES                          0               0         0         0
      ELEMENT DELETES                     228               0         0         0
      SYSTEM DELETES                        0               0         0         0
      ATTRIBUTE DELETES                     0               0         0         0
      USER DELETES                          0               0         0         0
      CLASS DELETES                         0               0         0         0
      CLASS UPDATES                         0               0         1         0
      USER UPDATES                          0               0         0         0
      ATTRIBUTE UPDATES                     0               0         0         0
      SYSTEM UPDATES                        0               0         0         0
      ELEMENT UPDATES                     228             228         0       109
      MODULE UPDATES                        0               0         0         0
      PROCESS UPDATES                       5               5         0         0
      QFILE UPDATES                         0               0         0         0
      TABLE UPDATES                         0               0         0         0
      FILE UPDATES                          0               0         0         0
      RECORD UPDATES                       20              20         0         0
      REPORT UPDATES                        0               0         0         0
      TRANSACTION UPDATES                   0               0         0         0
      PROGRAM UPDATES                       0               0         0         0
      DIALOG UPDATES                        1               1         0         0
      APPLICATION UPDATES                   0               0         0         0
      DCLOAD MODULE UPDATES                 7               7         0         0
      MESSAGE UPDATES                       0               0         0         0
    IDMSCHEM TRANSACTIONS                   2               0         0         0
      SCHEMA UPDATES                        1               1         0         0
    IDMSUBSC TRANSACTIONS                   0               0         0         0
      SUBSCHEMA DELETES                     5               5         0         0
      SUBSCHEMA UPDATES                     5               5         0         0
    RHDCMPUT TRANSACTIONS                   4               0         0         0
      MAP DELETES                           1               1         0         0
      PANEL DELETES                         1               1         0         0
      PANEL UPDATES                         1               1         0         0
      MAP ADDS/MODIFIES                     1               1         0         0
    ADSOBTAT TRANSACTIONS                   0               0         0         0

Extract Detail Report

The Extract Detail Report provides information about each entity that will be extracted from the source dictionary and entities for which delete syntax is created. The report displays the entity's type, name, version number, source dictionary, and dds node.

You can use this report to review every component of a system. The review is very helpful when you have large systems in development and need to know all of their components before a migration. You can review the Extract Detail Report to determine which components should be moved from testing into production.

You can also limit the information on this report by using the NOPRINT parameter. See the chapter "Parameters" for complete details.

The following report shows a sample Extract Detail Report. The report contains:

• entity type—the type of entity that will be extracted.
• entity name—the name of the entity that will be extracted.
• version number—the version from which the entity will be extracted.
• dictionary name—the name of the source dictionary from which the entity will be extracted.
• change-status—indicates which entities will be added, changed (modified), or dropped (not migrated).

 CA TOOLS   RELEASE    CA IDMS/Dictionary Migrator   DATE      TIME      PAGE
            nn.nn       EXTRACT DETAIL REPORT        mm/dd/yy  hh:mm:ss  nnnn
 
                             ECHO LIST OF ENTITIES TO BE EXTRACTED
 
    ENTITY-TYPE     ENTITY-NAME        VERSION    CHANGEONLY-STATUS  FROM DICTIONARY/NODE
    LOAD-DELETE     AAMAP1                 1
    LOAD-DELETE     AAX                    1
    LOAD-DELETE     EMPSSLR                1
    LOAD-DELETE     EMPSS01                1
    LOAD-DELETE     QALR04SS               1
    LOAD-DELETE     QALR07SS               1
    LOAD-DELETE     QALR17SS               1
    DIALOG-DELETE   AAX                    1
    SUBSCHEMA-DELET EMPSSLR              100
    SUBSCHEMA-DELET EMPSS01              100
    SUBSCHEMA-DELET QALR04SS             100
    SUBSCHEMA-DELET QALR07SS             100
    SUBSCHEMA-DELET QALR17SS             100
    SCHEMA-DELETE   EMPSCHM              100
    MAP-DELETE      AAMAP1                 1
    PROCESS-DELETE  AAX-PREMAP-1           1
    PROCESS-DELETE  AAX-RESPONSE-1         1
    PROCESS-DELETE  AAX-RESPONSE-4         1
    PROCESS-DELETE  AAX-RESPONSE-8         1
    PANEL-DELETE    AAMAP1-OLMPANEL        1
    RECORD-DELETE   AA-RECORD-1            1
    RECORD-DELETE   AA-RECORD-2            1
    RECORD-DELETE   AAX-RECORD-2           1
    RECORD-DELETE   COVERAGE             100
    RECORD-DELETE   DENTAL-CLAIM         100
    RECORD-DELETE   DEPARTMENT           100
    RECORD-DELETE   ELLIE-RECORD1          1
    RECORD-DELETE   ELLIE-RECORD2          1
    RECORD-DELETE   ELLIE-RECORD3          1
    RECORD-DELETE   EMPLOYEE             100
    RECORD-DELETE   EMPOSITION           100
    RECORD-DELETE   EXPERTISE            100
    RECORD-DELETE   HOSPITAL-CLAIM       100
    RECORD-DELETE   INSURANCE-PLAN       100
    RECORD-DELETE   JOB                  100
    RECORD-DELETE   NON-HOSP-CLAIM       100
    RECORD-DELETE   OFFICE               100
    RECORD-DELETE   SKILL                100
    RECORD-DELETE   SQLCA                  1
    RECORD-DELETE   STRUCTURE            100
    ELEMENT-DELETE  AA-ELEMENT-X           1
    ELEMENT-DELETE  AA-ELEMENT-1           1

Comparison Reports

CA IDMS Dictionary Migrator produces two reports--Entity Discrepancy Report and Entity Cross-Reference Report—that are the results of comparing source dictionary extractions to the object dictionary. The reports show where an extracted entity is used in the object dictionary.

When CA IDMS Dictionary Migrator extracts an entity from the source dictionary, it checks the object dictionary for that entity. Once the entity is located, it is checked for use by other entities in the object dictionary. If these entities appear in the list of extracted entities, the results of the search and comparison are provided on the Entity Cross-Reference Report. If the entity is used in the object dictionary by entities that do not appear in the list of extracted entities, their inconsistencies and the impact of migrating that entity are provided on the Entity Discrepancy Report.

Entity Discrepancy Report

The Extract Discrepancy Report addresses the second part of a successful migration, avoiding detrimental impact on other entities in the target dictionary. The messages in this report show the name of the migrated entity and the name of another entity that may be affected if the migration is done.

The sample reports shown in The following two reports illustrate how comparisons and inconsistencies are reported by CA IDMS Dictionary Migrator.

The Entity Discrepancy Report contains:

• entity type—the type of entity that will be extracted.
• entity name—the name of the entity that will be extracted.
• version number—the version from which the entity will be extracted.
• error message—the eight-character code and message text. Detailed information about the message (reasons and appropriate actions) is provided in the chapter "Messages.

 CA TOOLS   RELEASE          CA IDMS/Dictionary Migrator              DATE         TIME      PAGE
             nn.nn            ENTITY DISCREPANCY REPORT              mm/dd/yy    hh:mm:ss    nnnn
                    ENTITY DISCREPANCIES IN THE OBJECT DICTIONARY
 
 ENTITY-TYPE:  RECORD
 
 
 
 ENTITY-NAME            VERSION                 ERROR-MESSAGE
 
 TEST-REC                  1     VALD219C-EXTRACT FORCED FOR SUBSCHEMA    STSYNSUB  VERSION  1
                                 VALD219C-EXTRACT FORCED FOR SCHEMA       STATSCHM  VERSION  1

Entity Cross-Reference Report

The Entity Cross-Reference Report displays the extracted entities that are currently used in the object dictionary. The relationships of the extracted entities are reported in the sample Entity Cross-Reference Report in the following report.

If an extracted entity does not appear in either the Entity Cross-Reference Report or the Entity Discrepancy Report, the entity is not currently used by entities in the object dictionary.

The report can be omitted using the NOXREF parameter, or you can limit the amount of information on the Entity Cross-Reference Report by using the NOPRINT parameter. See the chapter "Parameters" for complete details.

The Entity Cross-Reference Report contains:

• extract entity—the type of entity extracted from the source dictionary
• entity name—the name of the entity in the source and object dictionaries
• version—the version number of the extracted entity
• related entity—the type of entity that uses the extracted entity in the object and source dictionaries
• related entity name—the name of the entity that uses the extracted entity in the object and in the source dictionaries
• version—the version of the related entity

               nn.nn         ENTITY CROSS-REFERENCE REPORT         mm/dd/yy   hh:mm:ss    nnnn
                       ENTITY RELATIONSHIPS IN OBJECT DICTIONARY
 
 
 EXTRACT-ENTITY   ENTITY-NAME          VERSION  RELATED-ENTITY     RELATED-ENTITY-NAME  VERSION
 ELEMENT          AT-SCR-BEGIN-REPLAY      1    RELATES TO ELEMENT  AT-WORK-RECORD-BEGIN     1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-DIALOG-NAME       1    RELATES TO ELEMENT  AT-WORK-RECORD-BEGIN     1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-DIALOG-NAME-ALT   1    RELATES TO ELEMENT  AT-WORK-RECORD-BEGIN     1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-DIALOG-VER        1    RELATES TO ELEMENT  AT-WORK-RECORD-BEGIN     1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-ERROR-LIT         1    RELATES TO ELEMENT  AT-SCR-HOLD              1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-ERROR-X           1    RELATES TO ELEMENT  AT-WORK-RECORD-BEGIN     1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-ERROR-9           1    RELATES TO ELEMENT  AT-SCR-ERROR-X           1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-HOLD              1    RELATES TO ELEMENT  AT-WORK-RECORD-BEGIN     1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-HOLD-STATUS       1    RELATES TO ELEMENT  AT-WORK-RECOD-BEGIN      1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-LIMIT             1    RELATES TO ELEMENT  AT-WORK-RECOD-BEGIN      1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-MAX-LINES         1    RELATES TO ELEMENT  AT-WORK-RECORD-BEGIN     1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-QUE-TO-SCR        1    RELATES TO ELEMENT  AT-WORK-RECORD-BEGIN     1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-REPLAY-DATE       1    RELATES TO ELEMENT  AT-WORK-RECORD-BEGIN     1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-REPLAY-NBR        1    RELATES TO ELEMENT  AT-WORK-RECORD-BEGIN     1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-REPLAY-TIME       1    RELATES TO ELEMENT  AT-WORK-RECORD-BEGIN     1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-REST              1    RELATES TO ELEMENT  AT-SCR-HOLD              1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-STAT-VALUE        1    RELATES TO ELEMENT  AT-SCR-HOLD              1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-SCR-TRACE-INFO        1    RELATES TO ELEMENT  AT-WORK-RECORD-BEGIN     1
                                                RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-WORK-RECORD-BEGIN     1    RELATES TO RECORD   AT-LINK-RECORD           1
 ELEMENT          AT-WORK-RECORD-END       1    RELATES TO RECORD   AT-LINK-RECORD           1

Syntax Production Report

The Syntax Production Report displays messages reflecting difficulties that have occurred in the creation of syntax. The messages will alert you to conditions which result in discontinuation of the migration process, and also indicate where the unsatisfactory conditions originate.

If messages do not appear in the Syntax Production Report, then syntax was successfully created for all entities that were extracted.

The following report shows a sample Syntax Production Report. The report contains:

• message code—the eight-character code of an error message.
• message text—information that explains the message code. Detailed information about the message--reasons and appropriate actions--is provided in the chapter "Messages".

 CA TOOLS      RELEASE         CA IDMS/Dictionary Migrator  DATE         TIME       PAGE
                nn.nn            SYNTAX PRODUCTION REPORTmm/dd/yy     hh:mm:ss     nnnn
 
 
 
 PS10608I NEW-COPY MODULE IS IDMS8735517033048                VERSION IS    1

Syntax Files Display Report

The Syntax Files Display Report shows the contents of each syntax file that will be used by the CA IDMS utilities and compilers or the Computer Associates utility to populate the object dictionary. This report is a hard copy of the syntax files produced by CA IDMS Dictionary Migrator. The Syntax Files Display Report is useful for verifying and documenting migrated entities.

The following report shows pages from a sample Syntax Files Display Report. The report contains:

• CA IDMS utility or compiler or CA IDMS Dictionary Migrator utility name—the name of the utility or compiler that uploads the file to the object dictionary
• syntax type—the type of syntax produced by CA IDMS Dictionary Migrator
• syntax—the syntax statements produced by CA IDMS Dictionary Migrator

 CA TOOLS     RELEASE         CA IDMS/Dictionary Migrator            DATE       TIME      PAGE
               nn.nn          SYNTAX FILES DISPLAY REPORT          mm/dd/yy   hh:mm:ss    nnnn
                           IDMSDDDL - ENTITY DELETION SYNTAX
 
       SIGNON
       USER 'DICST01      '
       PASSWORD=????????
       USAGE MODE IS PROTECTED UPDATE
       .
       SET OPTIONS FOR SESSION
       INPUT COLUMNS ARE   1 THRU 80
       DELETE IS ON
       LIST
       .
       ADD
       CLASS NAME IS MIGRATOR
           ATTRIBUTES ARE MANUAL PLURAL
           .
       ADD
       CLASS NAME IS 'KENN SYS'
           ATTRIBUTES ARE MANUAL PLURAL
           .
       ADD
       ATTRIBUTE NAME IS UM299 WITHIN CLASS MIGRATOR
           .
       ADD
       ATTRIBUTE NAME IS 'TEST REC' WITHIN CLASS 'KENN SYS'

Catalog Navigation Report

The Catalog Navigation Report provides information about each SQL table, view, schema, or table procedure that will be extracted from the source catalog and for which SQL CREATE syntax statements are generated. This report also highlights any error conditions encountered during the SQL catalog extraction process.

The report contains:

• message-code—the eight-character code of an informative or error message.
• message text—information that explains the message code. Detailed information about the message (reasons and

  Note: For more information about the message(reasons and appropriate actions) , see the chapter "Messages."

CA TOOLS                   RELEASE               CA IDMS/DICTIONARY MIGRATOR                 DATE             TIME          PAGE
MV9507                      Rnn.n                 CATALOG NAVIGATION REPORT                mm/dd/yy         16:03:44        0001
USMS004I EXTRACT SCHEMA - SCHEMA: DEMO
USMS002I EXTRACT TABLE - SCHEMA: DEMO , TABLE: EMPL
USMS010I EXTRACT CONSTRAINT - SCHEMA: DEMO , CONSTRAINT: EMP_POS
USMS002I EXTRACT TABLE - SCHEMA: DEMO , TABLE: POSITION
USMS010I EXTRACT CONSTRAINT - SCHEMA: DEMO , CONSTRAINT: MGR_EMPL
USMS010I EXTRACT CONSTRAINT - SCHEMA: DEMO , CONSTRAINT: EMP_DEPS
USMS002I EXTRACT TABLE - SCHEMA: DEMO , TABLE: DEPENDENTS
USMS010I EXTRACT CONSTRAINT - SCHEMA: DEMO , CONSTRAINT: DEPT_EMPL
USMS002I EXTRACT TABLE - SCHEMA: DEMO , TABLE: DEPT
USMS010I EXTRACT CONSTRAINT - SCHEMA: DEMO , CONSTRAINT: JOB_POS
USMS002I EXTRACT TABLE - SCHEMA: DEMO , TABLE: JOB
USMS010I EXTRACT CONSTRAINT - SCHEMA: DEMO , CONSTRAINT: DEPT_BUDGET
USMS002I EXTRACT TABLE - SCHEMA: DEMO , TABLE: BUDGET
USMS011I EXTRACT TABLE PROCEDURE - SCHEMA: DEMO , PROCEDURE: TESTPROC_1
USMS012I EXTRACT KEY - KEYNAME: PROC1_PRIME_KEY , ON SCHEMA: DEMO , PROCEDURE: TESTPROC_1
USMS012I EXTRACT KEY - KEYNAME: PROC1_UNIQ_KEY , ON SCHEMA: DEMO , PROCEDURE: TESTPROC_1
USMS012I EXTRACT KEY - KEYNAME: PROC1_STD_KEY , ON SCHEMA: DEMO , PROCEDURE: TESTPROC_1
USMS001I CATALOG NAVIGATION COMPLETED