Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2006
    Posts
    19

    Unanswered: SQL1092N trying to create database

    Windows, DB2 9

    We were recently acquisitioned and our network got changed, etc. We were trying to fix an issue and ended up (wrongly) setting the dbm cfg back to default values.

    Anyway, we can no longer create databases. I did drop one, but can't create one. I have checked the following:

    SYSCTRL_GROUP
    SYSADM_GROUP
    id is an administrator on box and in DB2ADMNS group
    DB2_GRP_LOOKUP

    What am I missing?

    thanks.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    What error message(s?) did you receive, at the time of creating databases?

  3. #3
    Join Date
    Nov 2006
    Posts
    19
    SQL1092N - authorization

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    check sysadm group. if correct change dbm cfg and remove the group name
    you should be able to do all in that case
    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 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Nov 2006
    Posts
    19
    Unfortunately, that didn't work and now I can't drop databases. It's been 2 years since I've tried to install LUW and that was on AIX, but we may just reinstall and see if that fixes it.

Posting Permissions

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