IBM Data and AI

Welcome to the IBM Data and AI Ideas Portal for Clients!

We welcome and appreciate your feedback on IBM Data and AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal. If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
  • Our team welcomes any feedback and suggestions you have for improving our offerings / products! This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

  • If you have not registered on this portal please click on the following link and register. To complete registration you will need to open the email you will receive from Aha to confirm your identity.

Additional Information:
  • The shorter URL for this site is:

  • To view our roadmaps:

  • Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

automatically activate a database when DB2 LUW is started

See PMR 14855,227,000.

We would like some way to automatically activate a specific database when a DB2 instance is started without the use of external scripts or DB2 APIs.
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jan 3 2019
  • Planned for future release
Idea Priority Medium
Customer Name StarQuest Ventures
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    22 Jun 03:40pm


    I agree in implementing this.. but we need to have control over it.. So a db-parameter or some other kind of management will be needed..

    ---> AGREE

    there are cases and cases when this is not desirable.

    ---> Changing this would effect the Veritas VCS DB2 UDB agent , which works very well with DB2 as you specify StartUpOpt = START, StartUpOpt = ACTIVATEDB to control db2 start behaviour . You typical set Veritas DB2 UDB agent to StartUpOpt = START not to activate the db2 database in db2 dpf environment , and then manual ACTIVATEDB or via vcs controlled script that is actioned when all db2 partitions have been started.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    5 May 01:00pm

    I agree in implementing this.. but we need to have control over it.. So a db-parameter or some other kind of management will be needed..

    there are cases and cases when this is not desirable.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    14 Jan 06:02pm

    Starting (db2start) and activating (db2 activate db) all databases in an instance after system reboot only setting a parameter would be so great and save time spending in scripting these things for different OS.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    5 Jul, 2019 01:29pm

    Why not having an external script run by DB2 when the starting process has completed in which we could add all the commands, like "db2 activate db xx".

    This would require no additional parameter and would provide a broader facility to start things after DB2 initialization is done.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    28 Jun, 2019 02:26pm

    For DB2LUW issues/tasks please contact Fady Badra or Patrick Fung
    Please contact Shimei Yan for management related issues.

    If you received this email in error, please advise the sender (by return email or otherwise) immediately. You have consented to receive the attached electronically at the above-noted email address; please retain a copy of this confirmation for future reference.

    RBC collects information from you and your device, including through use of cookies, in order to improve your digital experience and measure the effectiveness of RBC digital channels. Additional information may be found here .

    Si vous recevez ce courriel par erreur, veuillez en aviser l'exp��diteur imm��diatement, par retour de courriel ou par un autre moyen. Vous avez accept�� de recevoir le(s) document(s) ci-joint(s) par voie ��lectronique �� l'adresse courriel indiqu��e ci-dessus; veuillez conserver une copie de cette confirmation pour les fins de reference future.

    RBC recueille des renseignements fournis par vous et par votre appareil, de m��me que par l���utilisation de t��moins, dans le but d���am��liorer votre exp��rience num��rique et de mesurer l���efficacit�� de nos canaux num��riques. Vous pouvez obtenir des renseignements suppl��mentaires

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    13 Apr, 2019 08:01am

    Having a DB parameter telling the instance to activate it automatically as soon as instance starts woulds be nice!

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions