I'm working on an application retirement project where I've to retire 1800+ SQL databases. I used following DBBACTION for creating DB Aliases using a script:
/DBAAction=createnew /DBAName=RREntryPilot
/DBMSType=SQLSERVER /DBMSVersion=2008
/ConnectStr=product_rrentrypilot_db
/UserID=<userid> /Password=<password> /DBQualifier=product_rrentrypilot_db
/SPAction=Useexisting /SPQUALIFIER=Optim /Description='product_rrentrypilot_db'
/UNICODEDB=True /MULTIBYTEDB=False
/Task=DB
Ultimately, I would like to purge all of these DB Aliases using a script without going through Optim GUI. I didn't find any DBAACTION for purging DB Aliases and as per an update from IBM it is currently not possible to delete a DB Alias through pr0cnfg. Other objects from the Optim Directory can be deleted, but not a DBAlias.
Is there any other non-GUI option of getting rid of these multiple DB Aliases? If anybody has done this, could you please share your script with me?
Thanks,
------------------------------
Sanjay Marwah
Progressive Insurance
------------------------------
#InfoSphereOptim#Optim