Does your script do any filtering or other "massaging" of the data? If so,
it could be that the one domain is being massaged out.

Do you have more than one TSM server? If so, it is possible that the
script is logging into a different server.

It would help to see:

- The script

- The *complete* output from a manual SELECT

- The *complete* output from the script (don't use -DATAONLY=YES and don't
strip off any non-data messages... let's see the whole output)

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 01/29/2005
17:04:00:

> Hi,
>
>  I have a script running daily on a linux host to query for the
> status on backupjobs performed - but something wierd has happened
> within the last month or so... When doing a query in the script like:
>
> SELECT * FROM DOMAINS
>
> I get a list og 9 domains.... But when doing the same query manually
> (either via dsmc or on the command-line on the web-interface), the
> list has 10 policy domains ?? It is the exact same user-id/password,
> that is being used for the queries. Somehow policy-domain number 5
> (in the list) is missing when the query is performed from the script...
Why ??
>
> The server is running 5.2.2.5 (on a Windows 2000 Server) .....
>
> Regards,
> Brian Ipsen
>
>
> ---
> This mail was scanned for virus and spam by Progressive IT A/S.
> ---