Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2013
    Posts
    23

    Unanswered: Database Create Error

    RHEL 6.4 - 64bit - DB2 V9.7 - FP8

    I am gettting "SQL1042C An unexpected system error occurred. SQLSTATE=58004" error when I try to create database. Some db2diag.log file entries.................db2inst1 has permissions to the database path /home/db2inst1/db2inst1...........................Thanks.

    2013-12-16-15.32.19.778917-300 E2243E1071 LEVEL: Error (OS)
    PID : 3394 TID : 140597805442816PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    EDUID : 18 EDUNAME: db2loggr (SAMPLE) 0
    FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
    MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
    DIA8701C Access denied for resource "", operating system return code
    was "".
    CALLED : OS, -, open OSERR: EACCES (13)
    DATA #1 : Codepath, 8 bytes
    4:11:15:20:22:37
    DATA #2 : File name, 56 bytes
    /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/S0000001.LOG
    DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes
    SQLO_REVISE, SQLO_READWRITE, SQLO_SHAREREAD, SQLO_WRITETHRU
    DATA #4 : Hex integer, 4 bytes
    0x00000180


    2013-12-16-15.32.19.810351-300 I5247E485 LEVEL: Error
    PID : 3394 TID : 140597805442816PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    EDUID : 18 EDUNAME: db2loggr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgolf, probe:220
    RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
    DIA8701C Access denied for resource "", operating system return code
    was "".

    2013-12-16-15.32.19.821420-300 I5733E689 LEVEL: Error
    PID : 3394 TID : 140597805442816PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    EDUID : 18 EDUNAME: db2loggr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgolf, probe:220
    MESSAGE : Filename :
    DATA #1 : Hexdump, 56 bytes
    0x00007FDF7A3FC7D8 : 2F6F 7074 2F64 622F 7764 7064 6236 3038 /home/db2inst1/db2inst1
    0x00007FDF7A3FC7E8 : 2F4E 4F44 4530 3030 302F 5351 4C30 3030 /NODE0000/SQL000
    0x00007FDF7A3FC7F8 : 3031 2F53 514C 4F47 4449 522F 5330 3030 01/SQLOGDIR/S000
    0x00007FDF7A3FC808 : 3030 3031 2E4C 4F47 0001.LOG

    2013-12-16-15.32.19.832656-300 I6423E385 LEVEL: Error
    PID : 3394 TID : 140597805442816PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    EDUID : 18 EDUNAME: db2loggr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgole, probe:1710
    MESSAGE : Error -2079391743 opening database log extent 1:

    2013-12-16-15.32.19.846650-300 I6809E486 LEVEL: Error
    PID : 3394 TID : 140597805442816PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    EDUID : 18 EDUNAME: db2loggr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgicl, probe:1390
    RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
    DIA8701C Access denied for resource "", operating system return code
    was "".

    2013-12-16-15.32.19.863482-300 I7296E492 LEVEL: Error
    PID : 3394 TID : 140597805442816PROC : db2sysc 0

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    we believe what we see :
    display info for /home/db2inst1/
    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

  3. #3
    Join Date
    Jul 2013
    Posts
    23
    It is not a display info. The error is there ("Access Denied"
    DIA8701C Access denied for resource "", operating system return code
    was "".).................I figured the error happened because our network engineers installed McAfee without notifying me or anybody else. Once we put exclusions on the DB2 directory where the database is created, the error went away...........Now the question, If anyone has the list of the directories (or better yet DB2 files) that should be excluded from the McAfee antivirus scans, please let me know. I have never had to deal with this before. I can come up with a list but I like to make sure...................Thanks for any help.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    I would never install ant-virus on db-server.. exclude all that is related to db2 installation
    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
  •