Adrian, Try to add "displaymode=list" to your dsmadmc command ... Should do the trick !
You can also take advantage of "-datao=yes", to remove TSM specific headers ... Cheers Arnaud ************************************************************************ ****** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ************************************************************************ ****** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Davis, Adrian Sent: Friday, 09 February, 2007 14:12 To: [email protected] Subject: How do I stop dsmadmc reformatting output when doing selects on the command line? How do I stop "dsmadmc" reformatting output when doing "selects" on the command line or script? For example:- If I try... dsmadmc -id=script -pass=mypassword 'select * from db' ...I get... AVAIL_SPACE_MB: 17340 CAPACITY_MB: 17200 MAX_EXTENSION_MB: 140 MAX_REDUCTION_MB: 3048 PAGE_SIZE: 4096 USABLE_PAGES: 4403200 USED_PAGES: 2133480 PCT_UTILIZED: 48.4 MAX_PCT_UTILIZED: 82.3 PHYSICAL_VOLUMES: 34 BUFF_POOL_PAGES: 65536 TOTAL_BUFFER_REQ: 1357605 CACHE_HIT_PCT: 98.3 CACHE_WAIT_PCT: 0.0 BACKUP_RUNNING: NO BACKUP_TYPE: NUM_BACKUP_INCR: 0 BACKUP_CHG_MB: 107.5 BACKUP_CHG_PCT: 1.2 LAST_BACKUP_DATE: 2007-02-09 05:30:43.000000 ...Which is just what I want - However: If I do anything into a pipleline/redirect etc. the format is changed to... AVAIL_SPACE_MB CAPACITY_MB MAX_EXTENSION_MB MAX_REDUCTION_MB PAGE_SIZE USABLE_PAGES USED_PAGES PCT_UTILIZD MAX_PCT_UTILIZED PHYSICAL_VOLUMES BUFF_POOL_PAGES TOTAL_BUFFER_REQ CACHE_HIT_PCT CACHE_WAIT_PCT BACKUP_RNNING BACKUP_TYPE NUM_BACKUP_INCR BACKUP_CHG_MB BACKUP_CHG_PCT LAST_BACKUP_DATE -------------- ----------- ---------------- ---------------- --------- ------------ ----------- ----------- ---------------- ---------------- --------------- ---------------- ------------- -------------- ------------- ------------------ --------------- ------------- -------------- ------------------ 17340 17200 140 3048 4096 4403200 2133143 484 82.3 34 65536 1549477 98.3 0.0 NO 0 118.3 1.4 2007-02-09 05:30:43.000000 ...I tried using the "-outfile" option to write to a file. At first this seemed to work - even when I incorporated this into a script. But if I then called that script in a pipeline the format changed again - AAAAARGH!!! I much prefer the first version of the output as it is easier to process in scripts. Can anybody help?? Many Thanks, =Adrian= DISCLAIMER This message is confidential and intended solely for the use of the individual or entity it is addressed to. If you have received it in error, please contact the sender and delete the e-mail. To see the full version of this Disclaimer please click here: http://www.lewisham.gov.uk/AboutThisSite/EmailDisclaimer.htm For advice and assistance about online security and protection from internet threats visit the "Get Safe Online" website at www.getsafeonline.org
