1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

The tsm could not start after cut the active log

Discussion in 'TSM Operation' started by wang, Jan 29, 2018.

  1. wang

    wang Active Newcomer

    Joined:
    Jan 13, 2018
    Messages:
    9
    Likes Received:
    0
    hi,buddy,
    My client has the tsm6.3 on windows tsm server,last week thetsm warnning active log directory is full ,The active log is on the C:\tsm_log,So he crtl+X the files under C:\tsm_log to D:\tmp,hope the warnning is stop,but the tsm soon shutdown and the log say can't find the active log 0000160.LOG.
    after he crtl+V the oringnal file to sourse C:\tsm_log,the DB2 diag log say
    RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
    DIA8701C Access denied for resource "", operating system return code
    was "".
    follow is the detail:

    2018-01-24-13.52.35.720000+480 I37200128F489 LEVEL: Error
    PID : 5636 TID : 3852 PROC : db2syscs.exe
    INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
    EDUID : 3852 EDUNAME: db2loggr (TSMDB1)
    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 "".

    2018-01-24-13.52.35.720000+480 I37200619F535 LEVEL: Error
    PID : 5636 TID : 3852 PROC : db2syscs.exe
    INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
    EDUID : 3852 EDUNAME: db2loggr (TSMDB1)
    FUNCTION: DB2 UDB, data protection services, sqlpgolf, probe:220
    MESSAGE : Filename :
    DATA #1 : Hexdump, 27 bytes
    0x000000001611D6BC : 433A 5C54 534D 5F4C 4F47 5C6C 6F67 5C53 C:\TSM_LOG\log\S
    0x000000001611D6CC : 3030 3030 3136 302E 4C4F 47 0000160.LOG

    2018-01-24-13.52.35.735000+480 I37201156F389 LEVEL: Error
    PID : 5636 TID : 3852 PROC : db2syscs.exe
    INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
    EDUID : 3852 EDUNAME: db2loggr (TSMDB1)
    FUNCTION: DB2 UDB, data protection services, sqlpgole, probe:1710
    MESSAGE : Error -2079391743 opening database log extent 160:

    2018-01-24-13.52.35.735000+480 I37201547F503 LEVEL: Severe
    PID : 5636 TID : 3852 PROC : db2syscs.exe
    INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
    EDUID : 3852 EDUNAME: db2loggr (TSMDB1)
    FUNCTION: DB2 UDB, data protection services, sqlpgInitRecoverable, probe:1480
    RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
    DIA8701C Access denied for resource "", operating system return code
    was "".

    I watch the file permission,they are the same as the original,what should I do to solve the db2 issure?thx in advance.
     
  2.  
  3. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,886
    Likes Received:
    367
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    Restore the TSM DB from an earlier backup. You may need to drop all previous LOG data and may need to increase the LOG space.
     
  4. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,712
    Likes Received:
    375
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
  5. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,886
    Likes Received:
    367
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    I did not notice that the C: drive holds the logs :)
     
  6. wang

    wang Active Newcomer

    Joined:
    Jan 13, 2018
    Messages:
    9
    Likes Received:
    0
    thx for reply,unforture;y,they did not backup DB with caritage.I wonder why just crtl_X and Crtl_V make the db2 shutdown?any metherd save the TSM?
     
  7. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,712
    Likes Received:
    375
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    When you copy/paste files to a new location, the inherit the permissions of the new location. So they inherited D: permissions. When copying it back, if he logged in with a Windows account other than the instance owner ID, then the files would now be owned by that user. So two things:
    - make sure the files are owned by the instance owner and that the instance owner have full permissions on all the files
    - make sure he is logged in as the instance owner


    That explains why the logs filled, need to backup the DB to purge the archive log.
     
  8. wang

    wang Active Newcomer

    Joined:
    Jan 13, 2018
    Messages:
    9
    Likes Received:
    0
    thank you marclant,When we install tsm for windows,most of us use the windows administrator,this is quite diffrent from th linux and unix,
    did people use instance user id such as tsminst1 in windows?I used to install tsm on Linux and AIX´╝îThis is my first installation on windows platform.
     
  9. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,712
    Likes Received:
    375
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    Generally yes, but it's not a requirement, just general Windows security best practice to not the local administrator account. That's also how the step in the manual suggest to do it.
     
    wang likes this.

Share This Page