DB2 ID Removal

Posted on 2011-05-09
Last Modified: 2012-05-11
Hi there,
We have an internal check to make our applications compliant, during installation of db2 there was id which was created called idbp23646, now this id is no loner into the OS Level. This id has also been removed from the DB2 level, but when we run an internal audit report we do find an entry stating as follows and also gives us recommendations that it need to be created from OS level. Upon research I did find that the id idbp23646 cannot be deleted due a fact attached in the jpeg file..,However if still someone could provide a solution to get rid of the id and the gap be closed without exception it would indeed be helpful.

Violation Reported : Check Violation Jpeg
Solution : Check Recommendation Jpeg

Kindly please SOS

Note : When I create idbp23646 on the OS the Problem gets solved, but that does not suffice as a solution

If any one could help

Abdul H
 Violation idbp23646Gap-Solution.JPG
Question by:hainduab
    LVL 45

    Accepted Solution

    Hi Hainduab,

    In any system there must be a master (or owning) user.  Unix/Linux systems have the root account, Windows systems have the administrator account, etc.

    When you install DB2, you do so with a user that has sufficient privilege to install the product, supporting libraries, and any utilities that may be required.  That is typically the same user that is used to create separated instances of DB2.

    Trying to delete the account that essentially owns DB2 is impractical.  (I suspect that a security audit has found an "unused account" and you're scrambling to meet the criticisms of an audit.  If so, the correct solution is to tell the auditors that the account is necessary.)

    For the record, can you explain why you feel it necessary to delete this account?

    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Suggested Solutions

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now