Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Provided Answers: 11

    Unanswered: db2V10 and uid length limit

    db2 9.5 ese on P/linux fp 9
    we have been using ldap for authenticating users connecting to db2
    the ldap modules have been used for this purpose. all ok
    now we are planning for db2V10 and we decided to use transparent ldap instead. no problem as long as your userid is not longer than 8
    As we were not aware of this limit we have 50 users > 8chars
    Is anyone in the same scenario and how did you resolve this issue
    Yes : we could create new users and change the setting in was to use these new users.
    what about backward compatibility in DB2 when upgrading.
    thanks for all update/idea
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  2. #2
    Join Date
    Aug 2001
    I looked at this one recently and found the naming rules were the same in 9.7 and 10.1

    User, user ID and group naming rules - db2 10.1

    User, user ID and group naming rules - db2 9.7

    I don't understand why this eight character restriction is in place for the user id for authentication when authorization id can be 128 chars. ;-(
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts