Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: SQL0902C A system error

    db2 "CREATE DB WPSDB using codeset UTF-8
    territory us PAGESIZE 8192"
    SQL0902C A system error (reason code = "") occurred. Subsequent SQL
    statements cannot be processed. SQLSTATE=58005

    above error i am getting ...
    OS:windows 2003
    db2:v9.1

    i created a user and added to administrators group and db2admins group as well

    i created a instance using db2icrt <instance name> -u usernae,password

    now i connect to tat instance using " set db2instance=db2inst2"

    db2start

    i tried to create database , but i am getting above error
    DBM CFG is as follows

    SYSADM group name (SYSADM_GROUP) =
    SYSCTRL group name (SYSCTRL_GROUP) =
    SYSMAINT group name (SYSMAINT_GROUP) =
    SYSMON group name (SYSMON_GROUP) =

    i am installed db2 which comes along with TDS, LDAP is also is there...

    diag info:
    2011-10-17-14.42.20.840000+330 E108863H368 LEVEL: Error (OS)
    PID : 4696 TID : 1620 PROC : db2syscs.exe
    INSTANCE: DB2INST2 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloImpersonateLocalSystem, probe:20
    MESSAGE : ZRC=0x83000005=-2097151995
    CALLED : OS, -, OpenProcessToken
    OSERR : 5 "Access is denied."

    2011-10-17-14.42.20.840000+330 I109233H282 LEVEL: Severe
    PID : 4696 TID : 1620 PROC : db2syscs.exe
    INSTANCE: DB2INST2 NODE : 000
    FUNCTION: DB2 UDB, common communication, sqlccGetIPCs, probe:20
    RETCODE : ZRC=0x83000005=-2097151995

    2011-10-17-14.42.20.840000+330 I109517H350 LEVEL: Severe
    PID : 4696 TID : 1620 PROC : db2syscs.exe
    INSTANCE: DB2INST2 NODE : 000
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
    MESSAGE : User ID
    DATA #1 : Hexdump, 4 bytes
    0x0281FAC0 : 0000 0000 ....

    2011-10-17-14.42.20.840000+330 I109869H465 LEVEL: Severe
    PID : 4192 TID : 3460 PROC : db2bp.exe
    INSTANCE: DB2INST2 NODE : 000
    FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcCommConnect, probe:10
    MESSAGE : ZRC=0x82360001=-2110390271=SQLJC_ERROR_ICE "SYSTEM ERROR"
    DIA8532C An internal processing error has occurred.
    DATA #1 : String, 11 bytes
    CCI Error:
    DATA #2 : unsigned integer, 4 bytes
    81
    Pls help me out...
    Last edited by ravichandrapratap; 10-17-11 at 06:18.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    first of all : change SYSADM_GROUP to the group this user is belonging
    has this user local admin on this machine
    there are other requirements - see
    Required user accounts for installation of DB2 server products (Windows)
    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

Posting Permissions

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