Log Record Timestamp

[login to unmask email]

Log Record Timestamp
Hi all.
Do you know how to read the timestamp of a log record? I've read the Admin
guide, where it is said that in Log record header there is a field of 8
bytes that is the LRHTIME. Is this the time of the creation of this record?
How can I translate it to a understandable by me date and time in the
format of yyyymmddhhmmssss or something like this?
Thank you

Fatima

***************************************************************************
AVISO DE CONFIDENCIALIDADE: Esta mensagem, assim como os ficheiros
eventualmente anexos, é confidencial e reservada apenas ao conhecimento
da(s) pessoa(s) nela indicada(s) como destinatária(s). Se não é o seu
destinatário, solicitamos que não faça qualquer uso do respectivo conteúdo
e proceda à sua destruição, notificando o remetente.
LIMITAÇÃO DE RESPONSABILIDADE: A segurança da transmissão de informação
por via electrónica não pode ser garantida pelo remetente, o qual, em
consequência, não se responsabiliza por qualquer facto susceptível de
afectar a sua integridade.

CONFIDENTIALITY NOTICE: This message, as well as existing attached files,
is confidential and intended exclusively for the individual(s) named as
addressees. If you are not the intended recipient, you are kindly requested
not to make any use whatsoever of its contents and to proceed to the
destruction of the message, thereby notifying the sender.
DISCLAIMER: The sender of this message can not ensure the security of its
electronical transmission and consequently does not accept liability for
any fact which may interfere with the integrity of its content.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

gerhard heiss

Re: Log Record Timestamp
(in response to Fatima.Osorio@BPORTUGAL.PT)
possibly this might help:

SELECT TIMESTAMP( X'BA7389BBCC0C0002' )
FROM SYSIBM.SYSDUMMY1;
---------+---------+---------+---------
2003-12-10-23.05.16.662976
NUMBER OF ROWS SELECTED 1

regards
gerhard


-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Thursday, December 11, 2003 4:36 PM
To: [login to unmask email]
Subject: Log Record Timestamp


Hi all.
Do you know how to read the timestamp of a log record? I've read the Admin guide, where it is said that in Log record header there is a field of 8 bytes that is the LRHTIME. Is this the time of the creation of this record? How can I translate it to a understandable by me date and time in the format of yyyymmddhhmmssss or something like this? Thank you

Fatima

***************************************************************************
AVISO DE CONFIDENCIALIDADE: Esta mensagem, assim como os ficheiros eventualmente anexos, é confidencial e reservada apenas ao conhecimento
da(s) pessoa(s) nela indicada(s) como destinatária(s). Se não é o seu destinatário, solicitamos que não faça qualquer uso do respectivo conteúdo e proceda à sua destruição, notificando o remetente. LIMITAÇÃO DE RESPONSABILIDADE: A segurança da transmissão de informação por via electrónica não pode ser garantida pelo remetente, o qual, em consequência, não se responsabiliza por qualquer facto susceptível de afectar a sua integridade.

CONFIDENTIALITY NOTICE: This message, as well as existing attached files, is confidential and intended exclusively for the individual(s) named as addressees. If you are not the intended recipient, you are kindly requested not to make any use whatsoever of its contents and to proceed to the destruction of the message, thereby notifying the sender.
DISCLAIMER: The sender of this message can not ensure the security of its electronical transmission and consequently does not accept liability for any fact which may interfere with the integrity of its content.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

michael bell

Re: Log Record Timestamp
(in response to gerhard heiss)
I haven't checked the log records myself but most of the time fields in DB2
internals are STCK format. see the 370 principles of operations for more
details on the actual format (time of day clock). there is an ASM macro
STCKCONV that will convert it to more conventional formats. The connect
token that causes -818 is a modified STCK format so you might be able to use
some code that displays that in normal date/time format.

Mike Bell
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of [login to unmask email]
Sent: Thursday, December 11, 2003 9:36 AM
To: [login to unmask email]
Subject: Log Record Timestamp


Hi all.
Do you know how to read the timestamp of a log record? I've read the Admin
guide, where it is said that in Log record header there is a field of 8
bytes that is the LRHTIME. Is this the time of the creation of this record?
How can I translate it to a understandable by me date and time in the
format of yyyymmddhhmmssss or something like this?
Thank you

Fatima

***************************************************************************
AVISO DE CONFIDENCIALIDADE: Esta mensagem, assim como os ficheiros
eventualmente anexos, é confidencial e reservada apenas ao conhecimento
da(s) pessoa(s) nela indicada(s) como destinatária(s). Se não é o seu
destinatário, solicitamos que não faça qualquer uso do respectivo conteúdo
e proceda à sua destruição, notificando o remetente.
LIMITAÇÃO DE RESPONSABILIDADE: A segurança da transmissão de informação
por via electrónica não pode ser garantida pelo remetente, o qual, em
consequência, não se responsabiliza por qualquer facto susceptível de
afectar a sua integridade.

CONFIDENTIALITY NOTICE: This message, as well as existing attached files,
is confidential and intended exclusively for the individual(s) named as
addressees. If you are not the intended recipient, you are kindly requested
not to make any use whatsoever of its contents and to proceed to the
destruction of the message, thereby notifying the sender.
DISCLAIMER: The sender of this message can not ensure the security of its
electronical transmission and consequently does not accept liability for
any fact which may interfere with the integrity of its content.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Max Scarpa

Re: Log Record Timestamp
(in response to michael bell)
You can use also (if you like REXX):

/*REXX*/
TRACE O
TOD='BA7389BBCC0C0002'X
TDATE = X'000000000000000000'
ADDRESS LINKPGM "BLSUXTOD TOD TDATE"
PARSE VALUE TDATE WITH MM "/" DD "/" YY HR ":" MIN ":" SEC
SAY TDATE
EXIT

It gives the same result of a previous post (useful as well). I use it for
'decoding' SMF/GTF header timestamp

12/10/2003 23:05:16

HTH

Max Scarpa

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: Log Record Timestamp
(in response to Max Scarpa)
Thank you.

Fatima

***************************************************************************
AVISO DE CONFIDENCIALIDADE: Esta mensagem, assim como os ficheiros
eventualmente anexos, é confidencial e reservada apenas ao conhecimento
da(s) pessoa(s) nela indicada(s) como destinatária(s). Se não é o seu
destinatário, solicitamos que não faça qualquer uso do respectivo conteúdo
e proceda à sua destruição, notificando o remetente.
LIMITAÇÃO DE RESPONSABILIDADE: A segurança da transmissão de informação
por via electrónica não pode ser garantida pelo remetente, o qual, em
consequência, não se responsabiliza por qualquer facto susceptível de
afectar a sua integridade.

CONFIDENTIALITY NOTICE: This message, as well as existing attached files,
is confidential and intended exclusively for the individual(s) named as
addressees. If you are not the intended recipient, you are kindly requested
not to make any use whatsoever of its contents and to proceed to the
destruction of the message, thereby notifying the sender.
DISCLAIMER: The sender of this message can not ensure the security of its
electronical transmission and consequently does not accept liability for
any fact which may interfere with the integrity of its content.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: Log Record Timestamp
(in response to Fatima.Osorio@BPORTUGAL.PT)
Thank you.

Fatima

***************************************************************************
AVISO DE CONFIDENCIALIDADE: Esta mensagem, assim como os ficheiros
eventualmente anexos, é confidencial e reservada apenas ao conhecimento
da(s) pessoa(s) nela indicada(s) como destinatária(s). Se não é o seu
destinatário, solicitamos que não faça qualquer uso do respectivo conteúdo
e proceda à sua destruição, notificando o remetente.
LIMITAÇÃO DE RESPONSABILIDADE: A segurança da transmissão de informação
por via electrónica não pode ser garantida pelo remetente, o qual, em
consequência, não se responsabiliza por qualquer facto susceptível de
afectar a sua integridade.

CONFIDENTIALITY NOTICE: This message, as well as existing attached files,
is confidential and intended exclusively for the individual(s) named as
addressees. If you are not the intended recipient, you are kindly requested
not to make any use whatsoever of its contents and to proceed to the
destruction of the message, thereby notifying the sender.
DISCLAIMER: The sender of this message can not ensure the security of its
electronical transmission and consequently does not accept liability for
any fact which may interfere with the integrity of its content.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


*************************************************************************************
The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.
*************************************************************************************

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm