cdr list template

The cdr list template command displays information about the templates on the server on which the command is run.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-cdr list template--+--------------------------+-------------->
                      |                      (1) |   
                      '-| Connect Option   |-----'   

   .--------------.              
   V              |  .-BRIEF-.   
>----+----------+-+--+-------+---------------------------------><
     '-template-'    '-FULL--'   

Notes:
  1. See Connect Option.
Element Purpose Restrictions Syntax
template Name of the template. The template must exist. Long Identifiers

Usage

The cdr list template command displays information about templates. If no templates are named, the command lists all templates in the Enterprise Replication domain. If one or more templates are named, the command displays the names, database names, and table names for those templates.

To display detailed information for your templates, use the FULL option.

You do not need to be user informix to use this command; any user can run it.

In hierarchical topology, leaf servers have limited information about other database servers in the Enterprise Replication domain. Therefore, when cdr list template is executed against a leaf server, it displays incomplete information about the other database servers.

The cdr list template command can be used while the replication server is in DDRBLOCK mode. Before using the cdr list template command you must set the DBSPACETEMP configuration parameter and create a temporary dbspace with the onspaces utility.

Examples

The following example displays detailed information about the templates on the current server:
cdr list template
The output from the previous command might be the following:
TEMPLATE            DATABASE            TABLES
==============================================
tem1                newcars             table1
                    newcars             table2 
                    newcars             table3
tem2                carparts            table1
                    carparts            table3
The following example displays detailed information about the template tem1:
cdr list template tem1 
The output from the previous command might be the following:
CURRENTLY DEFINED TEMPLATES
===========================
TEMPLATE:    tem1           
TEMPLATE ID: 6553605             
SERVER:      utah
DATABASE:    newcars                
REPLICATE:   tem1_utah_2_1_table1   
OWNER:       pravin
TABLE:       table1                

TEMPLATE:    tem1           
TEMPLATE ID: 6553605             
SERVER:      utah
DATABASE:    newcars                
REPLICATE:   tem1_utah_2_2_table2   
OWNER:       pravin
TABLE:       table2                

TEMPLATE:    tem1           
TEMPLATE ID: 6553605             
SERVER:      utah
DATABASE:    newcars                
REPLICATE:   tem1_utah_2_3_table3   
OWNER:       pravin
TABLE:       table3                

Copyright© 2018 HCL Technologies Limited