Change MEMLIB in Database

Some examples running with Control-M and Control-EM database.
Post Reply
User avatar
markus507
Nouveau
Nouveau
Posts: 1
Joined: 25 Jul 2012 12:00

Change MEMLIB in Database

Post by markus507 » 15 Oct 2012 9:45

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

User avatar
Kelly
Nouveau
Nouveau
Posts: 10
Joined: 25 Sep 2010 12:00

Database table name

Post by Kelly » 25 Oct 2012 1:30

The table name containing MEM_LIB attribute is DEF_JOB.

User avatar
mauriziog
Nouveau
Nouveau
Posts: 807
Joined: 08 Jun 2007 12:00
Location: Varese - Italy
Contact:

Post by mauriziog » 26 Oct 2012 12:01

- 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.

User avatar
Itatoncework
Nouveau
Nouveau
Posts: 2
Joined: 29 Dec 2012 12:00
Contact:

SQL Scripts

Post by Itatoncework » 29 Dec 2012 1:07

load tables in the control-M desktop and check if all is ok.

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

Post Reply