Re: Historical Server - creating a record session

#1

John Salvo <jmsalvo (AT) yahoo (DOT) com.au> wrote :

Quote:

Trying to initiate a recording session. What is wrong with what I am
doing below?

The command reference says that the timezone defaults to the local
timezone if none is specified.

Tried both with YYYY and YY as in the example.

$ isql -Usybase -SSYBASE_hist
Password:

1> hs_create_recording_session SYBASE_mon, 2,
"/usr/sybase/ASE-12_5/install/history", "2003/06/23 11:40", "2003/06/23
11:45"
2> go
Invalid range of date/time values.
(return status = 1)

1> hs_create_recording_session SYBASE_mon, 2,
"/usr/sybase/ASE-12_5/install/history", NULL, "2003/06/23 11:45"
2> go
Invalid range of date/time values.
(return status = 1)

1> hs_create_recording_session SYBASE_mon, 2,
"/usr/sybase/ASE-12_5/install/history", NULL, "03/06/23 11:45"
2> go
Invalid range of date/time values.
(return status = 1)
1

The commands look correct to me. An idea is creating
a recording session without explicit dates, then
looking at the date format shown by
hs_list sessions

Regards,
Mariano Corral

#2

Mariano Corral wrote:

Quote:

John Salvo <jmsalvo (AT) yahoo (DOT) com.au> wrote :

Trying to initiate a recording session. What is wrong with what I am
doing below?

The command reference says that the timezone defaults to the local
timezone if none is specified.

Tried both with YYYY and YY as in the example.

$ isql -Usybase -SSYBASE_hist
Password:

1> hs_create_recording_session SYBASE_mon, 2,
"/usr/sybase/ASE-12_5/install/history", "2003/06/23 11:40", "2003/06/23
11:45"
2> go
Invalid range of date/time values.
(return status = 1)

1> hs_create_recording_session SYBASE_mon, 2,
"/usr/sybase/ASE-12_5/install/history", NULL, "2003/06/23 11:45"
2> go
Invalid range of date/time values.
(return status = 1)

1> hs_create_recording_session SYBASE_mon, 2,
"/usr/sybase/ASE-12_5/install/history", NULL, "03/06/23 11:45"
2> go
Invalid range of date/time values.
(return status = 1)
1

The commands look correct to me. An idea is creating
a recording session without explicit dates, then
looking at the date format shown by
hs_list sessions

Regards,
Mariano Corral
I had similar problems... Its a real pain in the butt to get this

working. I had to specify the full time format... 2003/06/23 11:40
GMT+10" to get it working...and even then I had to play around with the
GMT numbers to get it working..

I have also seen it started without specifying any time (ie. using
null). Then use the hs_terminate (?) to stop the session.

Cheers,
Jason

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Historical Server - creating a record session

comp.databases.sybase comp.databases.sybase

Re: Historical Server - creating a record session - 06-24-2003 , 02:04 PM

Re: Historical Server - creating a record session - 07-06-2003 , 05:04 AM