Hi,
The following command
select * from events where -
events.status not in ('Completed','Future') and -
events.scheduled_start between -
'01/19/2001 07:00:00.000000' and '01/24/2001 07:00:00.000000'
produced the following output:
full output (all columns) see attached file resultaat10
ADSTAR Distributed Storage Manager
Command Line Administrative Interface - Version 3, Release 1, Level 0.6
(C) Copyright IBM Corporation, 1990, 1997, All Rights Reserved.
Session established with server HOOFDKANTOOR: MVS
Server Version 3, Release 7, Level 1.0
Server date/time: 01/25/2001 09:10:17 Last access: 01/25/2001 09:08:44
SCHEDULED_START ACTUAL_START DOMAIN_NAME
SCHEDULE_NAME NODE_NAME STATUS RESULT
REASON
------------------ ------------------ ------------------
------------------ ------------------ ---------- -----------
------------------
2001-01-19 FILESRV
WD_FS_INCR2330 S816124
Missed
23:30:00.000000
2001-01-22 FILESRV
WD_FS_INCR2330 S816124
Missed
23:30:00.000000
2001-01-23 2001-01-23 FILESRV
WD_FS_INCR1900 S8168B7 Failed
-99
19:00:00.000000
19:03:25.000000
2001-01-23 2001-01-23 FILESRV
WD_FS_INCR1900 SV063A8 Failed
1
19:00:00.000000
22:07:05.000000
2001-01-23 2001-01-23 FILESRV
WD_FS_INCR2330 S816124
Missed
23:30:00.000000
21:00:26.000000
ANS8002I Highest return code was 0.
Remark that the last but one entry seems to be invalid (ACTUAL_START precedes
SCHEDULED_START !)
The following command however
q ev * * begind=01/19/2001 begint=07:00:00 endd=01/24/2001 endt=07:00:00 ex=yes
produces:
full output (all columns) see attached file resultaat11
ADSTAR Distributed Storage Manager
Command Line Administrative Interface - Version 3, Release 1, Level 0.6
(C) Copyright IBM Corporation, 1990, 1997, All Rights Reserved.
Session established with server HOOFDKANTOOR: MVS
Server Version 3, Release 7, Level 1.0
Server date/time: 01/25/2001 09:20:04 Last access: 01/25/2001 09:19:13
ANS8000I Server command: 'q ev * * begind=01/19/2001 begint=07:00:00
endd=01/24/2001 endt=07:00:00 ex=yes'
Scheduled Start Actual Start Schedule Name Node
Name Status
-------------------- -------------------- -------------
------------- ---------
01/19/2001 23:30:00 WD_FS_INCR23-
S816124 Missed
30
01/22/2001 23:30:00 WD_FS_INCR23-
S816124 Missed
30
01/23/2001 19:00:00 01/23/2001 19:03:25 WD_FS_INCR19-
S8168B7 Failed
00
01/23/2001 19:00:00 01/23/2001 22:07:05 WD_FS_INCR19-
SV063A8 Failed
00
01/23/2001 23:30:00 WD_FS_INCR23-
S816124 Missed
30
ANS8002I Highest return code was 0.
The problem seems to be related with the sql query only.
What is the problem here ? Anyone seen this before ?
I did attach the original outputfiles (resultaat10 and resultaat11)
Xavier Merlin
ADSTAR Distributed Storage Manager
Command Line Administrative Interface - Version 3, Release 1, Level 0.6
(C) Copyright IBM Corporation, 1990, 1997, All Rights Reserved.
Session established with server HOOFDKANTOOR: MVS
Server Version 3, Release 7, Level 1.0
Server date/time: 01/25/2001 09:10:17 Last access: 01/25/2001 09:08:44
SCHEDULED_START ACTUAL_START DOMAIN_NAME SCHEDULE_NAME
NODE_NAME STATUS RESULT REASON
------------------ ------------------ ------------------
------------------ ------------------ ---------- -----------
------------------
2001-01-19 FILESRV WD_FS_INCR2330
S816124 Missed
23:30:00.000000
2001-01-22 FILESRV WD_FS_INCR2330
S816124 Missed
23:30:00.000000
2001-01-23 2001-01-23 FILESRV WD_FS_INCR1900
S8168B7 Failed -99
19:00:00.000000 19:03:25.000000
2001-01-23 2001-01-23 FILESRV WD_FS_INCR1900
SV063A8 Failed 1
19:00:00.000000 22:07:05.000000
2001-01-23 2001-01-23 FILESRV WD_FS_INCR2330
S816124 Missed
23:30:00.000000 21:00:26.000000
ANS8002I Highest return code was 0.
ADSTAR Distributed Storage Manager
Command Line Administrative Interface - Version 3, Release 1, Level 0.6
(C) Copyright IBM Corporation, 1990, 1997, All Rights Reserved.
Session established with server HOOFDKANTOOR: MVS
Server Version 3, Release 7, Level 1.0
Server date/time: 01/25/2001 09:20:04 Last access: 01/25/2001 09:19:13
ANS8000I Server command: 'q ev * * begind=01/19/2001 begint=07:00:00 endd=01/24/2001
endt=07:00:00 ex=yes'
Scheduled Start Actual Start Schedule Name Node Name
Status
-------------------- -------------------- ------------- -------------
---------
01/19/2001 23:30:00 WD_FS_INCR23- S816124
Missed
30
01/22/2001 23:30:00 WD_FS_INCR23- S816124
Missed
30
01/23/2001 19:00:00 01/23/2001 19:03:25 WD_FS_INCR19- S8168B7
Failed
00
01/23/2001 19:00:00 01/23/2001 22:07:05 WD_FS_INCR19- SV063A8
Failed
00
01/23/2001 23:30:00 WD_FS_INCR23- S816124
Missed
30
ANS8002I Highest return code was 0.
