Results 1 to 7 of 7

Thread: Log File?

  1. #1
    Join Date
    Mar 2013
    Posts
    8

    Unanswered: Log File?

    Hey guys...I just signed up and will likely lean on you all quite a bit. I am an OPs and IT Security guy now working on data warehouse maintenance and the like. Fairly green in this world. First question

    1. What is my most basic way (syntax too please to capture errors in a log file?

    Thanks

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if you mean : errors produced by db2 ?
    there are located in a file db2diag.log located in :
    db2 get dbm cfg |grep DIAGPATH usually /home/db2inst1/sqllib/db2dump
    (but not a good practice)
    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
    Mar 2013
    Posts
    8
    apologies, i mean i have job running and want to capture any errors it produces. At step 5 of this job (running in AIX) it launches a DB2 load command...how can i capture any errors that DB2 load job creates?

    Quote Originally Posted by przytula_guy View Post
    if you mean : errors produced by db2 ?
    there are located in a file db2diag.log located in :
    db2 get dbm cfg |grep DIAGPATH usually /home/db2inst1/sqllib/db2dump
    (but not a good practice)

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    with the load command you can specify a message file that will keep all info or reroute the output to a file (load ... > logfile)
    syntax detail is at
    LOAD command - IBM DB2 9.7 for Linux, UNIX, and 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

  5. #5
    Join Date
    Mar 2013
    Posts
    8
    Tks, i will check it out. Right now we have it as follows...

    in the db2 load command is this line;
    messages ${LOAD_ERR}

    ${LOAD_ERR} point to this in the mother job perse;
    LOAD_ERR=${EDR_LOG}/${JOBNAME}_load_errors.log



    Quote Originally Posted by przytula_guy View Post
    with the load command you can specify a message file that will keep all info or reroute the output to a file (load ... > logfile)
    syntax detail is at
    LOAD command - IBM DB2 9.7 for Linux, UNIX, and Windows

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    this is the file you are looking for
    ${EDR_LOG}/${JOBNAME}_load_errors.log with variables translated
    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

  7. #7
    Join Date
    Mar 2013
    Posts
    8
    yes agreed....but errors from the DB2 load are not being captured there.

    Quote Originally Posted by przytula_guy View Post
    this is the file you are looking for
    ${EDR_LOG}/${JOBNAME}_load_errors.log with variables translated

Posting Permissions

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