Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
  • 1.  optim database administrator

    Posted 05/20/20 02:15 PM
    in the old days (2010) there used to be a product optim  database administrator - but is not supported anymore
    is there a replacement product that can do version control of database objects ?

    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    #Db2


  • 2.  RE: optim database administrator

    Posted 05/22/20 09:36 AM
    Hi Guy, 

    I believe DSM - Data Server Manager is the replacement product for Optim.  But, Data Management Console is the new DSM!  :)

    I hope this helps.

    ------------------------------
    Louis Lariviere
    ------------------------------



  • 3.  RE: optim database administrator

    Posted 05/22/20 11:24 AM
    I accept dsm is the replacement. BUT : has dsm the same functions as optim administrator ??
    and dmc has even less possibilities than dsm ..   so we can not talk about a replacement

    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------



  • 4.  RE: optim database administrator

    Posted 05/25/20 03:22 AM
    Hi Louis,

    sorry no. IBM has got no replacement for a Db2 Admin Frontend like Db2 Control Center was for a long time.

    Well, yes, you can create objects in a database with DMC, but only if you can script the commands. For the occasional DBA it was quite easy with Control Center to create a bufferpool with a GUI, see tablespaces, etc.
    But on the other hand, if you administer your environments with scripts and maybe some source code control system in the background, you can keep your environments more consistently in modern times with agile deployments, and so on...

    Cheers

    ------------------------------
    Roland Schock
    Distinguished Engineer
    ARS Computer und Consulting GmbH
    Muenchen
    ------------------------------