Results 1 to 6 of 6
  1. #1
    Senior Member cwilloug's Avatar
    Join Date
    Sep 2006
    Location
    North Dakota
    Posts
    384
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Default Silly format question

    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

  2. #2
    Moderator mikeymac's Avatar
    Join Date
    Jun 2003
    Location
    Syracuse, NY
    Posts
    893
    Thanks
    8
    Thanked 12 Times in 12 Posts

    Default

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

  3. #3
    Senior Member cwilloug's Avatar
    Join Date
    Sep 2006
    Location
    North Dakota
    Posts
    384
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Default

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

  4. #4
    Senior Member
    Join Date
    Apr 2007
    Location
    United States
    Posts
    450
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Quote Originally Posted by mikeymac View Post
    Don't think you can. Just cycle your TSM server when you have a free moment.
    Sounds a lot like a MS product :-/

  5. #5
    Moderator mikeymac's Avatar
    Join Date
    Jun 2003
    Location
    Syracuse, NY
    Posts
    893
    Thanks
    8
    Thanked 12 Times in 12 Posts

    Default

    Quote Originally Posted by cwilloug View Post
    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.

  6. #6
    Senior Member
    Join Date
    Dec 2006
    Location
    northern front-range Colorado, USA
    Posts
    600
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

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

Similar Threads

  1. possible silly question
    By cheffern in forum TSM Server
    Replies: 2
    Last Post: 05-27-2010, 08:39 AM
  2. help, almost a silly question..
    By fdiperna in forum Management Client/Server
    Replies: 6
    Last Post: 04-29-2010, 04:05 PM
  3. Silly copy pool question....
    By cwilloug in forum Restore / Recovery Discussion
    Replies: 2
    Last Post: 10-08-2009, 01:09 PM
  4. Silly question about compression
    By kfiresmith in forum Backup / Archive Discussion
    Replies: 3
    Last Post: 02-19-2008, 06:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •