Silly format question

[cwilloug]

So I'm now over one million session numbers in TSM, and have a format issue, its not a big thing, but how can I add spaces to the sess number colum so its all on one line?

tsm: TSM>q sess

Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name
Number Method State Time Sent Recvd Type
------- ------ ------ ------ ------- ------- ----- -------- -------------------
1,074,3 Tcp/Ip Run 0 S 988.0 K 105 Admin WinNT Cxxx
29
1,076,8 Tcp/Ip Run 0 S 6.7 K 347 Admin WinNT Cxxx
54
1,076,9 Tcp/Ip IdleW 33.1 M 1.2 K 134 Admin WinNT DOSxxxx
13
1,076,9 Tcp/Ip Run 0 S 120 196 Admin AIX Uxxxxx
58
1,076,9 Tcp/Ip IdleW 23 S 1.6 K 272 Node WinNT ESxxxxxx
60
1,076,9 Tcp/Ip Run 0 S 14.5 K 591 Node WinNT ESxxxxxx
62

[mikeymac]

Don't think you can. Just cycle your TSM server when you have a free moment.

[cwilloug]

That's not the answer I was looking for.... lol

[mikeatkc]

Don't think you can. Just cycle your TSM server when you have a free moment.

Sounds a lot like a MS product :-/

[mikeymac]

That's not the answer I was looking for.... lol

Alright, alright!

Well, you can do a query against the sessions table instead.

SELECT SESSION_ID,COMMMETHOD,STATE,WAIT_SECONDS,BYTES_SEN T,BYTES_RECEIVED,SESSION_TYPE,CLIENT_PLATFORM,CLIE NT_NAME FROM SESSIONS

Cut out the fields you don't think you need, and format the time and bytes fields so that they are easier to read.

This query probably has just about everything I'd want:

select session_id,state,wait_seconds,bytes_sent,bytes_rec eived,client_name from sessions

Stick that in a script, and run it when the mood strikes you.

[n9hmg]

-tabdelimited on your dsmadmc commandline. Much more readable, and trivial to chop up in text processing.