Db2

 View Only

Welcome to the Db2 Community! 

Communicate directly with IBM subject matter experts, learn from the experiences of fellow db2 users, and have the opportunity to share your own best practices! The Discussions tab great venue to ask questions of your peers and IBM subject matter experts to share best practices, pitfalls to avoid, and to learn from each other. Navigate to the Blogs tab to read about the latest and greatest, how-tos, best practices, and use cases from our experts and experienced product users. We would love for you to blog with us! IBMers can blog without approval. All other users please apply here to become a blogger. Lastly, don't forget to check up all of our upcoming Events as well as past resources located in the Library tab.

 

As a member of this online user community, you gain:

  • Direct engagement with IBM subject matter experts
  • Tips and tricks from your industry peers
  • News, announcements, and enhancement details
  • Learning and certification opportunities

You’ll also get information regarding our regional and virtual user group meetings, upcoming webinars, how-to blogs, and training. We invite you to participate and ask that you contact support@communitysite.ibm.com with any questions.

Db2 Resources:


#Cloud
#DCW

  • RE: CREATE TRIGGER

    Posted by: Mark Gillis, 3 days ago
    Answer
    Found in: Db2

    Thanks Jan and Mark for digging into this for me. It was the SECURED option and the consequent requirement for SECADM authority that was causing the issue in the ...

  • Found in: Db2 Discussions

    Hi, What issue did you have with NetBackup? David. ------------------------------ David Williams Senior Database Platform Engineer ...

  • RE: CREATE TRIGGER

    Posted by: Mark Barinstein, 5 days ago
    Answer
    Found in: Db2

    If the SECURED option is specified, the privileges held by the authorization ID of the statement must additionally include SECADM or CREATE_SECURE_OBJECT authority ...

  • RE: install db2 V12

    Posted by: Guy Przytula, 5 days ago
    Discussion
    Found in: Db2 Discussions

    many thanks - this resolved my problem ------------------------------ Thanks for all answers Best Regards, Guy Przytula ------------------------------

  • Found in: Db2 Discussions

    Had same issues with anything other than TMS. Lots of issues with netbackup Sent from my iPad

  • RE: CREATE TRIGGER

    Posted by: Jan Nelken, 5 days ago
    Answer
    Found in: Db2

    Mark! Standard Help Desk answer: Works for me :-) Environment: Windows 11 Db2 V11.5.9 SB50441 Running as db2admin (equivalent of Linux instance owner): User db2admin ...

  • RE: CREATE TRIGGER

    Posted by: Mark Barinstein, 5 days ago
    Answer
    Found in: Db2

    DB2 may think, that you don't have DBADM. What's the result of the following query? SELECT * FROM TABLE(AUTH_LIST_AUTHORITIES_FOR_AUTHID('DB2ADMIN', 'U')) WHERE ...

  • RE: install db2 V12

    Posted by: Guy Przytula, 5 days ago
    Discussion
    Found in: Db2 Discussions

    Many thanks for the answer. I will try and feedback Best Regards, Groeten Guy

  • RE: install db2 V12

    Posted by: Jan Nelken, 5 days ago
    Discussion
    Found in: Db2 Discussions

    AFAIK .fencedID is owned by fenced user: ------------------------------ Jan Nelken Persistent Systems Ltd Cracow +48 783 109 863 ----------------- ...

  • RE: install db2 V12

    Posted by: Philip Nelson, 5 days ago
    Discussion
    Found in: Db2 Discussions

    This is because of new protections around files in recent Linux versions. You need to turn this off temporarily while you run the upgrade and then turn it back ...

Quick Links

Upcoming Data Management Events

  • Db2 13 for z/OS has been generally available for several years. Db2 12 for z/OS is going End of Support December 31, 2025. Db2 for z/OS customers must migrate or acquire extended support contracts. ...

     Wed April 09, 2025  |  01:00 PM - 02:00 PM ET

Group News