Query event output - No match found - RC11 - TSM - 7.1.3

xyzegg

ADSM.ORG Member
Joined
Jun 27, 2011
Messages
48
Reaction score
0
Points
0
PREDATAR Control23

Hi,


I need help to understand why the query event below is returing code 11 (No match found using this criteria). Query actlog display messages about this node in the correct time according to the schedule definition.


tsm: BKPRJ1R>q node FOO-DB-BACKUP-RESTORE

Node Name Platform Policy Domain Days Since Days Since Locked?
Name Last Acce- Password
ss Set
------------------------- -------- -------------- ---------- ---------- -------
FOO-DB-BACKUP-RESTORE Linux PD_BAR <1 323 No
x86-64


tsm: BKPRJ1R>

tsm: BKPRJ1R>q sched * * node=FOO-DB-BACKUP-RESTORE f=d

Policy Domain Name: PD_BAR
Schedule Name: FOO-DB-BACKUP-RESTORE_D_0092
Description: XXXXXX

Action: Incremental
Subaction:
Options: -PRESChedulecmd="/scripts/rootPreSchedule2g.sh"
-POSTSChedulecmd="/scripts/rootPosSchedule2g.-
sh"
Objects:
Priority: 5
Start Date/Time: 05/28/2015 03:00:00
Duration: 1 Hour(s)
Maximum Run Time (Minutes): 0
Schedule Style: Enhanced
Period:
Day of Week: Any
Month: Any
Day of Month: Any
Week of Month: Any
Expiration:
Last Update by (administrator): xxx.yyy
Last Update Date/Time: 04/14/2016 12:06:49
Associated Nodes: FOO-DB-BACKUP-RESTORE
Managing profile:


tsm: BKPRJ1R>

tsm: BKPRJ1R>q assoc PD_BAR FOO-DB-BACKUP-RESTORE_D_0092

Policy Domain Name: PD_BAR
Schedule Name: FOO-DB-BACKUP-RESTORE_D_0092
Associated Nodes: FOO-DB-BACKUP-RESTORE

tsm: BKPRJ1R>

tsm: BKPRJ1R>q event * * node=FOO-DB-BACKUP-RESTORE
ANR2034E QUERY EVENT: No match found using this criteria.
ANS8001I Return code 11.

tsm: BKPRJ1R>q event * * node=FOO-DB-BACKUP-RESTORE EXceptionsonly=No
ANR2034E QUERY EVENT: No match found using this criteria.
ANS8001I Return code 11.

tsm: BKPRJ1R>q event * * node=FOO-DB-BACKUP-RESTORE EXceptionsonly=Yes
ANR2034E QUERY EVENT: No match found using this criteria.
ANS8001I Return code 11.

tsm: BKPRJ1R>


tsm: BKPRJ1R>q actlog search=FOO-DB-BACKUP-RESTORE begintime=03:00

Date/Time Message
-------------------- ----------------------------------------------------------
04/14/2016 03:00:00 ANR2561I Schedule prompter contacting
FOO-DB-BACKUP-RESTORE (session 198960) to start a
scheduled operation. (SESSION: 10)
04/14/2016 03:00:02 ANR0403I Session 198960 ended for node
FOO-DB-BACKUP-RESTORE (). (SESSION: 10)
04/14/2016 03:00:02 ANR0406I Session 198962 started for node
FOO-DB-BACKUP-RESTORE (Linux x86-64) (Tcp/Ip
FOO-DB-BACKUP-RESTORE.xxxx.yyy.zz(49944)). (SESSION:
198962)
04/14/2016 03:00:03 ANR0406I Session 198964 started for node
FOO-DB-BACKUP-RESTORE (Linux x86-64) (Tcp/Ip
FOO-DB-BACKUP-RESTORE.xxxx.yyy.zz(49945)). (SESSION:
198964)
...

tsm: BKPRJ1R>q actlog node=FOO-DB-BACKUP-RESTORE begintime=03:00

Date/Time Message
-------------------- ----------------------------------------------------------
04/14/2016 03:56:49 ANE4952I (Session: 198962, Node: FOO-DB-BACKUP-RESTORE)
Total number of objects inspected: 8,077
(SESSION: 198962)
04/14/2016 03:56:49 ANE4954I (Session: 198962, Node: FOO-DB-BACKUP-RESTORE)
Total number of objects backed up: 1,478
(SESSION: 198962)
04/14/2016 03:56:49 ANE4958I (Session: 198962, Node: FOO-DB-BACKUP-RESTORE)
Total number of objects updated: 0
(SESSION: 198962)
...





It works well with others nodes like this one:


tsm: BKPRJ1R>q node FOO-P1G-POSTGRES_DB_P

Node Name Platform Policy Domain Days Since Days Since Locked?
Name Last Acce- Password
ss Set
------------------------- -------- -------------- ---------- ---------- -------
FOO-P1G-POSTGRES_DB_P Linux PD_FOO <1 878 No
x86-64

tsm: BKPRJ1R>q sched * * node=FOO-P1G-POSTGRES_DB_P

Domain * Schedule Name Action Start Date/Time Duration Period Day
------------ - ---------------- ------ -------------------- -------- ------ ---
PD_FOO FOO-P1G-POSTGRE- Inc Bk 04/25/2012 12:30:00 30 M 1 H Any
S_DB_P_0092

tsm: BKPRJ1R>q sched * * node=FOO-P1G-POSTGRES_DB_P f=d

Policy Domain Name: PD_FOO
Schedule Name: FOO-P1G-POSTGRES_DB_P_0092
Description:

Action: Incremental
Subaction:
Options: -PRESChedulecmd="/xxx/yyy/pgsql/pgprd01/scr-
ipts/rootPreArchive.sh"
-POSTSChedulecmd="/xxx/yyy/pgsql/pgprd01/s-
cripts/rootPosArchive.sh"
Objects: /xxx/yyy/pgsql/pgprd01/archive/
Priority: 4
Start Date/Time: 04/25/2012 12:30:00
Duration: 30 Minute(s)
Maximum Run Time (Minutes): 0
Schedule Style: Classic
Period: 1 Hour(s)
Day of Week: Any
Month:
Day of Month:
Week of Month:
Expiration:
Last Update by (administrator): xxxxx.yyy
Last Update Date/Time: 04/08/2016 16:30:50
Associated Nodes: FOO-P1G-POSTGRES_DB_P
Managing profile:


tsm: BKPRJ1R>q event * * node=FOO-P1G-POSTGRES_DB_P

Scheduled Start Actual Start Schedule Name Node Name Status
-------------------- -------------------- ------------- ------------- ---------
04/14/2016 00:30:00 04/14/2016 00:30:13 FOO-P1G-POST- FOO-P1G-POST- Completed
GRES_DB_P_0- GRES_DB_P
092
04/14/2016 01:30:00 04/14/2016 01:30:25 FOO-P1G-POST- FOO-P1G-POST- Completed
GRES_DB_P_0- GRES_DB_P
092
 
PREDATAR Control23

tsm: BKPRJ1R>q event * * node=FOO-DB-BACKUP-RESTORE
ANR2034E QUERY EVENT: No match found using this criteria.
ANS8001I Return code 11.
It means it hasn't done a scheduled backup recently and none are scheduled. Or at least not since: Last Update Date/Time: 04/08/2016 16:30:50
 
PREDATAR Control23

run Q SCH * node=FOO-P1G-POSTGRES_DB_P f=d
it would show you when exactly the backup is scheduled. I hope you have done the association.
 
Top