ADSM-L

Message of activity log truncated to 250 with SELECT

2003-04-03 11:08:09
Subject: Message of activity log truncated to 250 with SELECT
From: Christian Bagard <christian.bagard AT WANADOO DOT FR>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 3 Apr 2003 17:55:39 +0200
Hello,

Have somebody any idea :

Subject : Length (chars) of activity log messages

In TSM Database : 
Table : Columns, Actlog, LENGTH of Message is specified to max 250.
Some messages are longer than 250.
By example : ANR8300E which is a drive error (with a long SENSE 00:01:xxxxxx, 
etc.)

With SELECT : 
DSMADMC -id -pa SELECT MSGNO, LENGTH(MESSAGE) AS LNG, MESSAGE FROM ACTLOG
messages are 250 truncated

But not with Query which doesn't truncate the string (if the field in the DB is 
really limited to 250, from where come the extra-datas used by Query ?)

It' possible to reproduce in easier way than a drive error (!) by sending a 
long syntax select and search for
ANR2017I message, by example.

Thanks
Regards

Christian Bagard
SOS-Restore
Aix-en-Provence - France
 

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