InfoSphere Optim

 View Only

Purging multiple DBAliases by running a script

  • 1.  Purging multiple DBAliases by running a script

    Posted Tue June 04, 2019 01:34 PM
    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