Carl,

I experienced a similar, and probably related problem using "select * from
PROCESSES".

It appears that the STATUS column contains new line characters, which are
not being handled correctly, since with -tab output, newlines delimit the
output for each row.

I am running on Solaris 2.6, and depending on the nature of the data, ADSM
might hang or crash.

I have referred the problem to IBM, and am awaiting a fix.  Meanwhile, I
modified my code to parse the processes individually, and without the -tab
option, as follows:

Issue:

"dsmadmc -id=admin -pa=admin -out -tab -noc select process_num, process
from processes"

Parse the tab delimited output to extract each process_num.

Issue the following for each process_num:

"dsmadmc -id=admin -pa=admin -out -noc select status from processes where
process_num="

Parse the output for the single column without tabs.


I hope this helps.

Ajax Dempsey


At 09:56 AM 2/5/99 +1100, you wrote:
>Is anyone else seeing this?
>
>When I do a
>
>dsmadmc -user=xxxx -pa=xxxx -outf -tab "q proc"
>
>and there is a process with a lot of text running, the query ends with
>
>ANS8001I Return code 4.
>
>and hangs.  Often for 30 minutes or more before returning.
>
>It seems to truncate the output at 207 characters as well.
>
>
>This has been causing me a lot of grief as my automated operations scripts
>are hanging and the operators aren't happy.
>
>
>Carl.
>
>