ADSM-L

Re: Help with select

2002-10-16 11:37:36
Subject: Re: Help with select
From: Yahya Ilyas <Yahya.Ilyas AT ASU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 16 Oct 2002 08:36:14 -0700
You can try following:
        query event * schedulename begindate=-1 enddate=today
(query event domainname schedulename)

-----
Yahya Ilyas
Systems Programmer Sr
Systems Integration & Management
Information Technology
Arizona State University, Tempe, AZ 85287-0101





-----Original Message-----
From: Michael Moore [mailto:Michael_Moore AT VFC DOT COM]
Sent: Wednesday, October 16, 2002 7:20 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Help with select


I am trying to setup some reporting on events on the server.  Here is what
I see:

If I do a 'Q EVENTS * * BEGINDATE=TODAY-1 ENDDATE=TODAY-1'  I get the
following:

Scheduled Start      Actual Start         Schedule Name Node Name
Status
-------------------- -------------------- ------------- -------------
---------
10/15/2002 12:17:42                       TEST_DAILY_1- 02LC0
Missed
                                           800
10/15/2002 12:17:42                       TEST_DAILY_1- MANAGE_ME
Missed
                                           800
10/15/2002 16:27:00  10/15/2002 16:28:02  SRV_DAILY_FI- ITGC2AFILER
Completed
                                           LER
10/15/2002 16:58:00  10/15/2002 17:03:54  SRV_DR_DAILY- ITGC2A01
Failed
                                           _1730
10/15/2002 16:58:00  10/15/2002 17:03:54  SRV_DR_DAILY- ITGC2AS1
Completed
                                           _1730
10/15/2002 16:58:00  10/15/2002 17:03:52  SRV_DR_DAILY- ITGC2AARTHUR4
Completed
                                           _1730
10/15/2002 16:58:00                       SRV_DR_DAILY- ITGC2APRODTR-
Missed
                                           _1730         AN
10/15/2002 16:58:00  10/15/2002 17:03:51  SRV_DR_DAILY- ITGC2ARFSM
Completed


But, if I do a 'select * from events where schedule_name
='SRV_DR_DAILY_1730' and date(scheduled_start)> current date -2 days'  I
get the following:

ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.

Thanks for any help someone can provide!

Oh, by the way, I am running v4.2.2.12 on OS/390 v2.10

Michael Moore
VF Services Inc.
121 Smith Street
Greensboro,  NC  27420-1488

Voice: 336-332-4423
Fax: 336-332-4544

<Prev in Thread] Current Thread [Next in Thread>