1 of 1

xinfo

This option specifies parameters for XINFO analysis. It is used in case of DELETE processes where Procman/HOS checks for example whether deleted procedures or SYSIN files are used by other existing jobs. As real XINFO table and column names can differ from the default ones then this setting ensures that correct tables and columns are always known. This option also allows you to set an user that is used for reading data from XINFO database and also allows you to set values for XXRDATCLIENT, XXRDATENV and XXRDATINFO columns, which are important if your XINFO installation has multi client support activated.

You can use an asterisk in the place of 'target_system' or 'client'. Then the setting becomes valid for all systems or clients.
The 'name' parameter maps table names (without a prefix) to real database table names used in SQL queries. In the example any SQL query that reads data from XXRTDDF table uses XINFO43.XXRTDDF table name in the generated SQL queries.
Column names are in vast majority (if not in all cases) unchanged in real XINFO installations. If this is your case then the key and value (which have a meaning of Procman/HOS names and DB table columns) are equal.

'xinfo' => array(
    'SYSH_ID' => array(                                     // target_system
        '*' => array(                                       // client
            'table' => array(
                'XXRTDDF' => array(
                    'name' => 'XINFO43.XXRTDDF',
                    'col'  => array(
                        'XXRDATCLIENT'  => 'XXRDATCLIENT',  // Client
                        'XXRDATENV'     => 'XXRDATENV',     // Environment
                        'XXRDATINFO'    => 'XXRDATINFO',    // DatAddInfo
                        'DDFJN'         => 'DDFJN',         // Jobname
                        'DDFSTEP#'      => 'DDFSTEP#',      // Stepnumber
                        'DDFPGMN'       => 'DDFPGMN',       // Programname
                        'DDFDDN'        => 'DDFDDN',        // DD-name
                        'DDFCC#'        => 'DDFCC#',        // Concat-number
                        'DDFDSN'        => 'DDFDSN',        // Dataset Name
                        'DDFDSMEMBER'   => 'DDFDSMEMBER',   // Member/Generation
                        'DDFLIB'        => 'DDFLIB',        // JCL-Lib
                        'DDFMEMB'       => 'DDFMEMB',       // Member
                        'DDFCALLEDPROC' => 'DDFCALLEDPROC', // Called Procedure
                        'DDFCALLEDLIB'  => 'DDFCALLEDLIB'   // Proclib (called)
                    )
                ),
                'XXRTEXE' => array(
                    'name' => 'XINFO43.XXRTEXE',
                    'col'  => array(
                        'XXRDATCLIENT' => 'XXRDATCLIENT',   // Client
                        'XXRDATENV'    => 'XXRDATENV',      // Environment
                        'XXRDATINFO'   => 'XXRDATINFO',     // DatAddInfo
                        'EXEJN'        => 'EXEJN',          // Jobname
                        'EXEMEMB'      => 'EXEMEMB',        // Member
                        'EXELIB'       => 'EXELIB',         // JCL-lib
                        'EXESTEP#'     => 'EXESTEP#',       // Stepnumber
                        'EXEPROCN'     => 'EXEPROCN',       // Procedurename
                        'EXECALLEDLIB' => 'EXECALLEDLIB',   // Proclib (called)
                        'EXETYPE'      => 'EXETYPE',        // Type (PROC/PGM)
                        'EXEJOBSN'     => 'EXEJOBSN'        // JobStepname
                    )
                ),
                'XXRTOP' => array(
                    'name' => 'XINFO43.XXRTOP',
                    'col'  => array(
                        'XXRDATCLIENT' => 'XXRDATCLIENT',   // Client
                        'XXRDATENV'    => 'XXRDATENV',      // Environment
                        'XXRDATINFO'   => 'XXRDATINFO',     // DatAddInfo
                        'ADRID'        => 'ADRID',          // Application ID
                        'ADROPJN'      => 'ADROPJN',        // Jobname
                        'ADROPNO'      => 'ADROPNO',        // Operation Number
                        'ADRWSID'      => 'ADRWSID'         // Workstation
                    )
                ),
                'XXRTDEP' => array(
                    'name' => 'XINFO43.XXRTDEP',
                    'col'  => array(
                        'XXRDATCLIENT' => 'XXRDATCLIENT',   // Client
                        'XXRDATENV'    => 'XXRDATENV',      // Environment
                        'XXRDATINFO'   => 'XXRDATINFO',     // DatAddInfo
                        'ADROPEAD'     => 'ADROPEAD',       // Pred. Appl.
                        'ADROPEJN'     => 'ADROPEJN',       // Pred. Jobname
                        'ADREP_OPNO'   => 'ADREP_OPNO',     // Pred. Op. No.
                        'ADREP_WSID'   => 'ADREP_WSID',     // Pred. Workstation
                        'ADRID'        => 'ADRID',          // Application ID
                        'ADROPJN'      => 'ADROPJN',        // Jobname
                        'ADROPNO'      => 'ADROPNO',        // Operation Number
                        'ADRWSID'      => 'ADRWSID',        // Workstation
                        'ADRDEPEXT'    => 'ADRDEPEXT'       // Ext. Pred. Y/N/I/E
                    )
                ),
                'XXRTJOB' => array(
                    'name' => 'XINFO43.XXRTJOB',
                    'col'  => array(
                        'XXRDATCLIENT' => 'XXRDATCLIENT',   // Client
                        'XXRDATENV'    => 'XXRDATENV',      // Environment
                        'XXRDATINFO'   => 'XXRDATINFO',     // DatAddInfo
                        'JOBLIB'       => 'JOBLIB',         // JCL-Lib
                        'JOBMEMB'      => 'JOBMEMB',        // Member
                        'JOBJN'        => 'JOBJN'           // Jobname
                    )
                ),
                'system' => array (
                    'XXRDATCLIENT' => 'CLIENT1',
                    'XXRDATENV' => 'ENV1',
                    'XXRDATINFO' => 'INFO1'
                ),
                'conn' => array (
                    'host'   => '',
                    'port'   => '',
                    'schema' => '',
                    'type'   => 'db2',
                    'alias'  => 'DALLASA',
                    'user'   => 'T391D',
                    'pwd'    => '=FlhlaP5h/bM8wWycs0E2yPqPHRZb7uulC5e6gsBBuEQ=='
                )
            )
        )
    )
)

In case of multi-client XINFO installation you can edit parameters in 'system' array. In the example 'XXRDATCLIENT='CLIENT1' AND XXRDATENV='ENV1' AND XXRDATINFO='INFO1'' is added to every SQL query listing data from XINFO database. The 'system' array is optional. Do not specify it if you don't need it.
Parameters in 'conn' array configure connection parameters used for querying data from XINFO database. Do not specify this block if the user used for all other Procman/HOS database queries should also be used for the XINFO database.

xinfo

You can use an asterisk in the place of 'target_system' or 'client'. Then the setting becomes valid for all systems or clients.
The 'name' parameter maps table names (without a prefix) to real database table names used in SQL queries. In the example any SQL query that reads data from XXRTDDF table uses XINFO43.XXRTDDF table name in the generated SQL queries.
Column names are in vast majority (if not in all cases) unchanged in real XINFO installations. If this is your case then the key and value (which have a meaning of Procman/HOS names and DB table columns) are equal.

'xinfo' => array(
    'SYSH_ID' => array(                                     // target_system
        '*' => array(                                       // client
            'table' => array(
                'XXRTDDF' => array(
                    'name' => 'XINFO43.XXRTDDF',
                    'col'  => array(
                        'XXRDATCLIENT'  => 'XXRDATCLIENT',  // Client
                        'XXRDATENV'     => 'XXRDATENV',     // Environment
                        'XXRDATINFO'    => 'XXRDATINFO',    // DatAddInfo
                        'DDFJN'         => 'DDFJN',         // Jobname
                        'DDFSTEP#'      => 'DDFSTEP#',      // Stepnumber
                        'DDFPGMN'       => 'DDFPGMN',       // Programname
                        'DDFDDN'        => 'DDFDDN',        // DD-name
                        'DDFCC#'        => 'DDFCC#',        // Concat-number
                        'DDFDSN'        => 'DDFDSN',        // Dataset Name
                        'DDFDSMEMBER'   => 'DDFDSMEMBER',   // Member/Generation
                        'DDFLIB'        => 'DDFLIB',        // JCL-Lib
                        'DDFMEMB'       => 'DDFMEMB',       // Member
                        'DDFCALLEDPROC' => 'DDFCALLEDPROC', // Called Procedure
                        'DDFCALLEDLIB'  => 'DDFCALLEDLIB'   // Proclib (called)
                    )
                ),
                'XXRTEXE' => array(
                    'name' => 'XINFO43.XXRTEXE',
                    'col'  => array(
                        'XXRDATCLIENT' => 'XXRDATCLIENT',   // Client
                        'XXRDATENV'    => 'XXRDATENV',      // Environment
                        'XXRDATINFO'   => 'XXRDATINFO',     // DatAddInfo
                        'EXEJN'        => 'EXEJN',          // Jobname
                        'EXEMEMB'      => 'EXEMEMB',        // Member
                        'EXELIB'       => 'EXELIB',         // JCL-lib
                        'EXESTEP#'     => 'EXESTEP#',       // Stepnumber
                        'EXEPROCN'     => 'EXEPROCN',       // Procedurename
                        'EXECALLEDLIB' => 'EXECALLEDLIB',   // Proclib (called)
                        'EXETYPE'      => 'EXETYPE',        // Type (PROC/PGM)
                        'EXEJOBSN'     => 'EXEJOBSN'        // JobStepname
                    )
                ),
                'XXRTOP' => array(
                    'name' => 'XINFO43.XXRTOP',
                    'col'  => array(
                        'XXRDATCLIENT' => 'XXRDATCLIENT',   // Client
                        'XXRDATENV'    => 'XXRDATENV',      // Environment
                        'XXRDATINFO'   => 'XXRDATINFO',     // DatAddInfo
                        'ADRID'        => 'ADRID',          // Application ID
                        'ADROPJN'      => 'ADROPJN',        // Jobname
                        'ADROPNO'      => 'ADROPNO',        // Operation Number
                        'ADRWSID'      => 'ADRWSID'         // Workstation
                    )
                ),
                'XXRTDEP' => array(
                    'name' => 'XINFO43.XXRTDEP',
                    'col'  => array(
                        'XXRDATCLIENT' => 'XXRDATCLIENT',   // Client
                        'XXRDATENV'    => 'XXRDATENV',      // Environment
                        'XXRDATINFO'   => 'XXRDATINFO',     // DatAddInfo
                        'ADROPEAD'     => 'ADROPEAD',       // Pred. Appl.
                        'ADROPEJN'     => 'ADROPEJN',       // Pred. Jobname
                        'ADREP_OPNO'   => 'ADREP_OPNO',     // Pred. Op. No.
                        'ADREP_WSID'   => 'ADREP_WSID',     // Pred. Workstation
                        'ADRID'        => 'ADRID',          // Application ID
                        'ADROPJN'      => 'ADROPJN',        // Jobname
                        'ADROPNO'      => 'ADROPNO',        // Operation Number
                        'ADRWSID'      => 'ADRWSID',        // Workstation
                        'ADRDEPEXT'    => 'ADRDEPEXT'       // Ext. Pred. Y/N/I/E
                    )
                ),
                'XXRTJOB' => array(
                    'name' => 'XINFO43.XXRTJOB',
                    'col'  => array(
                        'XXRDATCLIENT' => 'XXRDATCLIENT',   // Client
                        'XXRDATENV'    => 'XXRDATENV',      // Environment
                        'XXRDATINFO'   => 'XXRDATINFO',     // DatAddInfo
                        'JOBLIB'       => 'JOBLIB',         // JCL-Lib
                        'JOBMEMB'      => 'JOBMEMB',        // Member
                        'JOBJN'        => 'JOBJN'           // Jobname
                    )
                ),
                'system' => array (
                    'XXRDATCLIENT' => 'CLIENT1',
                    'XXRDATENV' => 'ENV1',
                    'XXRDATINFO' => 'INFO1'
                ),
                'conn' => array (
                    'host'   => '',
                    'port'   => '',
                    'schema' => '',
                    'type'   => 'db2',
                    'alias'  => 'DALLASA',
                    'user'   => 'T391D',
                    'pwd'    => '=FlhlaP5h/bM8wWycs0E2yPqPHRZb7uulC5e6gsBBuEQ=='
                )
            )
        )
    )
)

In case of multi-client XINFO installation you can edit parameters in 'system' array. In the example 'XXRDATCLIENT='CLIENT1' AND XXRDATENV='ENV1' AND XXRDATINFO='INFO1'' is added to every SQL query listing data from XINFO database. The 'system' array is optional. Do not specify it if you don't need it.
Parameters in 'conn' array configure connection parameters used for querying data from XINFO database. Do not specify this block if the user used for all other Procman/HOS database queries should also be used for the XINFO database.