AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Tradeskillmaster api down4/21/2023 ![]() ![]() MESSAGE : SQL2033N An error occurred while accessing TSM during the processing Scoll down to find the following message: FUNCTION: DB2 UDB, database utilities, sqlubHandleTSMError, probe:1320 Locate the message: FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1850 Locate the db2diag.log in TSM binary location, eg: /home/tsminst1/sqllib/dbdump ![]() SELECT cast(TO_CHAR(CHAR(actual_start),'YYYY-MM-DD HH24:MI:SS')as varchar(19)) as ACTUAL_START_TIME,cast(TO_CHAR(CHAR(completed),'YYYY-MM-DD HH24:MI:SS') as varchar (19)) as COMPLETED_TIME, TRANSLATE('a bc:de:fg', DIGITS(completed - actual_start), '_abcdefgh_',' ') as "ELAPTIME",cast(schedule_name as varchar (8)) as SCHEDULE, cast(status as varchar(10)) as STATUS FROM events WHERE scheduled_start> char(current date - 7 day) AND domain_name='DXI-OFF'įound the following message in actlog: ANR2968E Database backup terminated. ![]() SELECT cast(TO_CHAR(CHAR(actual_start),'YYYY-MM-DD HH24:MI:SS')as varchar(19)) as ACTUAL_START_TIME,cast(TO_CHAR(CHAR(completed),'YYYY-MM-DD HH24:MI:SS') as varchar (19)) as COMPLETED_TIME, TRANSLATE('a bc:de:fg', DIGITS(completed - actual_start), '_abcdefgh_',' ') as "ELAPTIME",cast(schedule_name as varchar (8)) as SCHEDULE, cast(status as varchar(10)) as STATUS FROM events WHERE scheduled_start> char(current_timestamp-24 hours) AND domain_name='DXI' SELECT cast(volume_name as varchar(10)) as VOLUMES,cast(TO_CHAR(CHAR(chg_time),'YYYY-MM-DD')as varchar(10)) as CHG_TIME,cast(PCT_UTILIZED as varchar(5)) as PCT,cast(status as varchar(10)) as STATUS FROM volumes WHERE STGPOOL_NAME='$1' and PCT_UTILIZED char(current_timestamp-24 hours) AND node_name=null ![]()
0 Comments
Read More
Leave a Reply. |