Db2 (On Premises and Cloud)

nested-group-icon.png

DB2

Expand all | Collapse all

optim database administrator

  • 1.  optim database administrator

    Posted Wed May 20, 2020 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
    ------------------------------


  • 2.  RE: optim database administrator

    Posted Fri May 22, 2020 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 Fri May 22, 2020 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 Mon May 25, 2020 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
    ------------------------------