Well Todd,
This is the TSM default. In order to get the output in the required format
you need to use the -outfile option. This way you will get the output as if
you are at the admin command line.
Like this:
dsmadmc -id=.... -pa=.... -outfile=<path_to_outfile> "your select goes
here"
Ilja G. Coolen
_____
ABP / USZO
CIS / BS / TB / Storage Management
Telefoon : +31(0)45 579 7938
Fax : +31(0)45 579 3990
Email : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Intranet
: Storage Web <http://intranet/cis_bstb/html_content/sm/index_sm.htm>
_____
- Everybody has a photographic memory, some just don't have film. -
-----Oorspronkelijk bericht-----
Van: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]Namens Pucky,
Todd M.
Verzonden: maandag 3 december 2001 13:44
Aan: [EMAIL PROTECTED]
Onderwerp: SQL Formatting on AIX scripts - SQLDISPLAYMODE
TSM Server: AIX 4.3.3
I have seen this issue addressed in the adsm archives, but never a clear
answer on how to solve it. I plan to use a script in a cron job on AIX, but
I need to have SQLDISPLAYMODE set to WIDE. Here is the part of my script
where I attempt to set the SQLDISPLAYMODE to WIDE and issue the query.
dsmadmc -id=xxxxxx -pas=xxxxxx "set sqldisplaymode wide"
dsmadmc -id=xxxxxx -pas=xxxxxx "select events.node_name, events.s
tatus, nodes.contact from events, nodes where events.domain_name='SERVER'
and ev
ents.schedule_name='SERVER_0300_0500' and (events.status='Missed' or
events.stat
us='Failed') and events.node_name=nodes.node_name" > $eventtmp
I have no problems when I issue these commands from the Admin Command Line,
but through the AIX script I always get SQL format of NARROW in the results
of my query. Any suggestions on how to get the SQLDISPLAYMODE WIDE command
to work in the AIX script would be greatly appreciated.
Thanks
Todd M. Pucky
The Timken Company
Global Information Systems
**********************************************************************
This message and any attachments are intended for the
individual or entity named above. If you are not the intended
recipient, please do not read, copy, use or disclose this
communication to others; also please notify the sender by
replying to this message, and then delete it from your system.
The Timken Company
**********************************************************************
