Results 1 to 8 of 8
  1. #1
    Join Date
    May 2012
    Location
    Chennai
    Posts
    45

    Question Unanswered: logarchmeth1 from disk to tsm

    Hi All,
    I have changed the logarchmeth1 from disk to tsm then stop and start the instance. But, archives logs are not going to tsm and it stayed in the default log path. I have taken online backup via tsm. so, tsm configuration is correct. I have listed error from diaglog. Can you give correct solution for this. (DB2 UDB ESE 9.1 FP5 )



    2012-08-03-14.59.43.195362+480 I107338920A292 LEVEL: Error
    PID : 17105052 TID : 1 PROC : db2logmgr (WAREHOUS) 0
    INSTANCE: db2inst9 NODE : 000
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogVendor, probe:1820
    RETCODE : ZRC=0x0000000B=11

    2012-08-03-14.59.43.207014+480 E107339213A438 LEVEL: Warning
    PID : 17105052 TID : 1 PROC : db2logmgr (WAREHOUS) 0
    INSTANCE: db2inst9 NODE : 000
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
    MESSAGE : ADM1848W Failed archive for log file "S0001100.LOG" to "TSM chain 0"
    from
    "/data/db2inst9/db/warehous/db2inst9/NODE0000/SQL00001/SQLOGDIR/".

    2012-08-03-14.59.43.207505+480 I107339652A432 LEVEL: Error
    PID : 17105052 TID : 1 PROC : db2logmgr (WAREHOUS) 0
    INSTANCE: db2inst9 NODE : 000
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3160
    MESSAGE : Failed to archive log file S0001100.LOG to TSM chain 0 from
    /data/db2inst9/db/warehous/db2inst9/NODE0000/SQL00001/SQLOGDIR/ with
    rc = 11.



    Thank you,

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    "I have listed error from diaglog. Can you give correct solution for this"
    have you tried to understand the rc it returns ??

    look in dsmrc.h
    rc=11 means
    define DSM_RS_ABORT_NO_STO_SPACE_SKIP 11
    http://www.lmgtfy.com/?q=API return ...e file dsmrc.h
    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
    May 2012
    Location
    Chennai
    Posts
    45
    Hi all,

    Please can you give correct suggesion for that issue.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    because you persist and do not want to have a look at the doc
    look at another entry in same forum
    http://www.dbforums.com/db2/1634024-...sm-v8-2-a.html
    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
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Look for the following line in the db2diag.log:
    MESSAGE : sqluvint failed! Vendor rc:

    This will give you the RC coming back from TSM. See the following thread for more info:
    http://www.dbforums.com/db2/1676558-...archiving.html

  6. #6
    Join Date
    May 2012
    Location
    Chennai
    Posts
    45

    Question logarchmeth1 from disk to tsm

    Hi all,

    I have changed the logarchmeth1 as tsm:db2logs. then i have stopped and started the instance. But same error i get. ALso, i have tsm space. It has more space in tsm.Can you give solution

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    you are really persistent..

    logarchmeth1 should be tsm and nothing else
    archive-backup pool is related to node name and entry in dsm.opt dsm.sys
    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

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    logarchmeth1 can be set to tsm:db2logs where db2logs is the mgmt class. But verify that:

    TSM
    If specified without any additional configuration parameters, this value indicates that log files should be archived on the local TSM server using the default management class. If followed by a colon( and a TSM management class, the log files will be archived using the specified management class.
    When archiving logs using TSM, before using the management class specified by the database configuration parameter, TSM first attempts to bind the object to the management class specified in the INCLUDE-EXCLUDE list found in the TSM client options file. If a match is not found, the default TSM management class specified on the TSM server will be used. TSM will then rebind the object to the management class specified by the database configuration parameter.
    Thus, the default management class, as well as the management class specified by the database configuration parameter, must contain an archive copy group, or the archive operation will fail.

    If the problem persists, perform the following:

    -> db2diag -A
    -> execute ARCHIVE LOG command
    -> attached db2diag.log here

Posting Permissions

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