It is currently 12 Dec 2017 7:06


Post new topic  Reply to topic  [ 4 posts ] 
Author Message
PostPosted: 15 Oct 2012 9:45 
Offline
Nouveau
Nouveau
User avatar

Joined: 25 Jul 2012 12:00
Posts: 1
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


Top
   
 Post subject: Database table name
PostPosted: 25 Oct 2012 1:30 
Offline
Nouveau
Nouveau
User avatar

Joined: 25 Sep 2010 12:00
Posts: 10
The table name containing MEM_LIB attribute is DEF_JOB.


Top
   
 Post subject:
PostPosted: 26 Oct 2012 12:01 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 807
Location: Varese - Italy
- 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.


Top
   
 Post subject: SQL Scripts
PostPosted: 29 Dec 2012 1:07 
Offline
Nouveau
Nouveau
User avatar

Joined: 29 Dec 2012 12:00
Posts: 2
load tables in the control-M desktop and check if all is ok.

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


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 4 posts ] 

All times are UTC+01:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved