The tsm could not start after cut the active log

wang

Active Newcomer
Joined
Jan 13, 2018
Messages
9
Reaction score
0
Points
0
PREDATAR Control23

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.
 
PREDATAR Control23

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.
 
PREDATAR Control23

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?
 
PREDATAR Control23

I wonder why just crtl_X and Crtl_V make the db2 shutdown?any metherd save the TSM?
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


y,they did not backup DB with caritage.
That explains why the logs filled, need to backup the DB to purge the archive log.
 
PREDATAR Control23

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.

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.
 
PREDATAR Control23

did people use instance user id such as tsminst1 in windows?
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.
 
Top