IBM Data Lifecycle - Integration and Governance Connect with experts and peers to elevate technical expertise, solve problems and share insights. Join / Log in
is there a command or file that indicates the refresh loader path for an instance without shutting down the instance ?
if the instance is down we can use dmconfigurets - edit instance - refresh loader path and we prompted with the current path
can it be retrieved from pointbase db : table ?
The undocumented dmmdcommander command can be used to open a read-only connection to the metadata database. dmmdcommander -I <instance>
dmmdcommander -I <instance>
This opens a CLI in which you can run SQL select commands and some other commands to set some options.
All commands are terminated with a semi-colon ;
The command help; displays basic information
The structure of the database is liable to change between different builds, but the following has been valid for all the Java-based CDC instances AFAIK, apart from the schema which also changes between various builds.
In the CLI enter the following commands
show system; -- note the schema name (e.g. V244)
set screenwidth 300;
select name, value from V244.PROPERTIES; - this will display the properties of the instance including the refresh loader path
select name, value from V244.PROPERTIES;
The command dmmdconsole -I <instance name> will display a GUI interface to the database, on Windows or *nix systems with a suitable graphical environment
dmmdconsole -I <instance name>
You can try this command:
echo "SET SCREENWIDTH 300; SELECT NAME,VALUE FROM $(echo "SELECT SCHEMANAME FROM POINTBASE.SYSSCHEMATA WHERE SCHEMANAME LIKE 'V%';" | ./dmmdcommander -I <instance_name> | grep V2).PROPERTIES;" | ./dmmdcommander -I <instance_name>
many thanks - this is giving what we need .....