Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2012
    Posts
    11
    Provided Answers: 1

    Unanswered: Error in AIX syslog when attempt made to rotate diag/nfy log

    Hi all,

    AIX 7.1.3.45
    DB2 ESE v9.7.0.5
    Running SAP workload

    In AIX log /var/adm/syslog I get following error messages. Obviously process cannot open/find log file, but is unclear which program tries to run this.

    Jan 17 21:38:44 HOSTNAME user:err|error DB2[33030304]: Open of log file "" failed with rc 0x800F007F Instance name: db2inst1 Node number: 0 Process ID: 33030304 Process name: db2 EDU ID: 1 EDU name: Thread ID: 1 Database name: Probe number: 2 Product Name: DB2 UDB Comp
    onent Name: command line process Function Name: clp_send_bpreq
    Jan 17 21:38:44 HOSTNAME user:err|error DB2[33030304]: Failed to get the rotate admin log file name: Return Code: 0x800f007f PID:33030304 TID:1
    Jan 17 21:38:49 HOSTNAME user:err|error DB2[33030306]: Open of log file "" failed with rc 0x800F007F Instance name: db2inst1 Node number: 0 Process ID: 33030306 Process name: db2 EDU ID: 1 EDU name: Thread ID: 1 Database name: Probe number: 2 Product Name: DB2 UDB Comp
    onent Name: command line process Function Name: clp_send_bpreq
    Jan 17 21:38:49 HOSTNAME user:err|error DB2[33030306]: Failed to get the rotate admin log file name: Return Code: 0x800f007f PID:33030306 TID:1

    DIAGLEVEL = 3
    DIAGSIZE = 1024

    I made script to capture occurrence of 'rotate' pattern in the script then capture PID info, but it seems process is active for a second and I cannot capture it to find out exactly what process command is. Diag/nfy size grows slowly and there is no need to rotate it.

    Has anyone encountered this issue before ?

    It has no impact but is annoying to see in logs
    I want to figure out what is causing it before I set DIAGSIZE to 0.

    Thanks!

    EDIT: File and directory permissions are not a problem.
    Last edited by postolar; 01-20-16 at 04:12.

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    Does your fenced user have write access to the directory where the db2diag.log files reside?
    You can get it with
    ls -l ~db2inst1/sqllib/ctrl/.fencedID
    Regards,
    Mark.

  3. #3
    Join Date
    Sep 2012
    Posts
    11
    Provided Answers: 1
    Hi Mark,

    Thanks for your reply.
    It does. In this instance fenced user is the same as instance owner.

    ls -l sqllib/ctrl/.fencedID
    -rw-rw-r-- 1 db2inst1 dbadmgrp 7 Feb 28 2013 sqllib/ctrl/.fencedID

    cat sqllib/ctrl/.fencedID
    db2inst1

    db2pd -fmp | grep -i user
    Fenced User: db2inst1

    ls -ld db2dump
    drwxrwxr-x 7 db2inst1 dbadmgrp 4096 Jan 20 12:00 db2dump
    Last edited by postolar; 01-21-16 at 09:00.

Posting Permissions

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