Please provide me the proper parameters to create new optim directory through command line.
Here i used below parameters.
saved in a txt file OptimDir.txt
and executed with below command
PR0CNFG /File=E:\Build\OptimDir.txt /AUTORUN=TRUE
But it didn't create directory.
Please help me regarding the same.
This topic has been locked.
9 replies Latest Post - 2012-10-18T15:59:29Z by SystemAdmin
Pinned topic Creating Optim Directory through command line
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-18T15:59:29Z at 2012-10-18T15:59:29Z by SystemAdmin
TulasiDas 2700027C1362 PostsACCEPTED ANSWER
Re: Creating Optim Directory through command line2012-08-23T05:06:48Z in response to SystemAdminHi,
I see some more keywords are missing, try by including below keywords:
SPQUALIFIER = schema name or owner ID
Rest of the keyword are looks good.
Re: Creating Optim Directory through command line2012-08-23T13:18:29Z in response to TulasiDasHello Tulasi,
Thanks for your respond for my question.
I added the parameter you mentioned,
But still it didn't create Directory, when i observed it was trying to create DB alias for existing directory.
Please find the attached screenshot for your response.
Kindly help me out. Thanks in advance.
Balachandra 2700027TN99 PostsACCEPTED ANSWER
Re: Creating Optim Directory through command line2012-08-23T13:41:44Z in response to SystemAdminHi,
The option for the creation of Optim Directory via command line is not a documented feature and IBM Optim does not recommend this. Please use the GUI approach for this function.
Re: Creating Optim Directory through command line2012-08-23T14:11:04Z in response to BalachandraHello Balachandra,
As we are doing automation of Optim command line execution we are trying to do end-to-end automation so it will be feasible if we get parameters to create Directory through cmndline.
Please help me.
Ducatiman 27000213JK58 PostsACCEPTED ANSWER
Re: Creating Optim Directory through command line2012-08-23T15:21:54Z in response to SystemAdminThere are three things you need to do to create and register the Optimdir without using the GUI:
1) Create the database for the Optim directory using database script e.g
CREATE DATABASE OPTMDIR AUTOMATIC STORAGE YES ON 'C:\' DBPATH ON 'C:\' USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM PAGESIZE 4096;
2) Load the Optim database stored procedures located in the Optim sub folder e.g. C:\IBM Optim\RT\BIN\SP\ORA112
3) modify the registry settings in HKEY_LOCAL_MACHINE\SOFTWARE\Princeton Softech\Relational Tools\PSTDIRECTORY
Re: Creating Optim Directory through command line2012-10-18T15:51:03Z in response to SystemAdminHello:
I imagine what you are looking to find are the saved Extract Requests that were saved to the PSTDirectory? If you open the Optim Gui and choose File->Open you will be presented
with the list of all of the objects that have been defined to Optim in an online display. We provide batch PR0CMND directives to run 'action' processes (Extract, etc.) and initiate Optim maintenance however there are no commands to interrogate the directory itself (although it is not a bad idea) ....