Online Log full date/time stamp on entries & verbo
Posted in 2012
Topics: Security, Permissions & Auditing, Logging & Checkpoints
Good morning IIUG community, Is there a Logging Jedi-Master out there who can tell me how to change logging settings for Informix IDS 11.50.FC6? I'm looking to have the Online Log with full date/time stamp on log entries instead of just the Time. Example: 08:27:58 listener-thread: err = -952: oserr = 0: errstr = <Some User>@<Some Computer>: User (<Some User>@<Some Computer>:)'s password is not correct for the database server. Is it possible to have the Online log have Date + Time at the beginning of each entry? Also, is there a verbosity level I can set to include more information in each log entry? Thanks for any advise with this question. Jonathan B. Smaby Pomona College -- "If you are not willing to risk the unusual, you will have to settle for the ordinary." - Jim Rohn ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.
Set the parameter MSG_DATE in onconfig to 1
onmode -wf MSG_DATE=1
Celso Cabral Coimbra
Administrador de Banco de Dados
ClearTech Ltda
"Trust at the heart of Communications"
Tel. (11) 3576-4509
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Jonathan
Smaby
Enviada em: quinta-feira, 8 de março de 2012 14:50
Para: ids@iiug.org
Assunto: Online Log full date/time stamp on entries & v.... [26492]
Good morning IIUG community,
Is there a Logging Jedi-Master out there who can tell me how to change logging
settings for Informix IDS 11.50.FC6? I'm looking to have the Online Log with
full date/time stamp on log entries instead of just the Time.
Example:
08:27:58 listener-thread: err = -952: oserr = 0: errstr = <Some User>@<Some
Computer>: User (<Some User>@<Some Computer>:)'s password is not correct for
the database server.
Is it possible to have the Online log have Date + Time at the beginning of
each entry? Also, is there a verbosity level I can set to include more
information in each log entry?
Thanks for any advise with this question.
Jonathan B. Smaby
Pomona College
--
"If you are not willing to risk the unusual, you will have to settle for the
ordinary." - Jim Rohn
-------------------------------------------------------------
This message has been scanned by Postini anti-virus software.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hello.
There´s an onconfig setting that can be changed online.
onmode -wm MSG_DATE=1
Just don´t forget to put it into your onconfig file, in case of an instance
bounce, that should stay as permanent, ok?
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Database Administrator
(cel) +55 11 7603-0358
> To: ids@iiug.org
> From: Jonathan.Smaby@pomona.edu
> Subject: Online Log full date/time stamp on entries & v.... [26492]
> Date: Thu, 8 Mar 2012 12:50:19 -0500
>
> Good morning IIUG community,
>
> Is there a Logging Jedi-Master out there who can tell me how to change
logging
> settings for Informix IDS 11.50.FC6? I'm looking to have the Online Log with
> full date/time stamp on log entries instead of just the Time.
>
> Example:
>
> 08:27:58 listener-thread: err = -952: oserr = 0: errstr = <Some User>@<Some
> Computer>: User (<Some User>@<Some Computer>:)'s password is not correct for
> the database server.
>
> Is it possible to have the Online log have Date + Time at the beginning of
> each entry? Also, is there a verbosity level I can set to include more
> information in each log entry?
>
> Thanks for any advise with this question.
>
> Jonathan B. Smaby
> Pomona College
> --
> "If you are not willing to risk the unusual, you will have to settle for the
> ordinary." - Jim Rohn
>
> -------------------------------------------------------------
> This message has been scanned by Postini anti-virus software.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>