Page 1 of 1

Change MEMLIB in Database

Posted: 15 Oct 2012 9:45
by markus507
Hello,

we're running Control-M in Version 6.2.01.300.

We are migrating one of our Application Servers therefore we need to change the value MEMLIB to point to the new directory/share

Is it possible to change the MEMLIB parameter directly in the database?
Can someone please tell me the name of the table?

Thank you
Markus

Database table name

Posted: 25 Oct 2012 1:30
by Kelly
The table name containing MEM_LIB attribute is DEF_JOB.

Posted: 26 Oct 2012 12:01
by mauriziog
- Export the tables in xml file (exportdeftable utility)
- open the xml file with a text editor and change the MEMLIB field
- import the tables with deftable utility (is like write action)
- load tables in the control-M desktop and check if all is ok
- do the UPLOAD action of all tables.

This is more flexible and with more security that modify the definitions on DB; in release 6.2 and 6.3 nad even 6.4 (you can save xml draft directly) I have used this method many many times for mass changes.

SQL Scripts

Posted: 29 Dec 2012 1:07
by Itatoncework
load tables in the control-M desktop and check if all is ok.

www.itatonce.com/it-consulting-services/