Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

db2batch from windows client: SQL1427N An instance attachment does not exist



I am trying to use db2batch from my XP client against a remote
database.
And here's what I am getting:

C:\work\Tuning\DB2\db2batch> db2batch -d oakl0 -a fs/fs -f
db2batch.sql
Running in Embedded Dynamic mode.

---------------------------------------------
--#SET PERF_DETAIL 5

Statement number: 1

select count(*) from files

1
--------------
     2715211


Number of rows retrieved is:        1
Number of rows sent to output is:   1

SQL1427N  An instance attachment does not exist.


Elapsed Time is:           1.772      seconds

---------------------------------------------



Summary of Results
==================
                Elapsed             Agent CPU         Rows      Rows
Statement #     Time (s)            Time (s)          Fetched  
Printed
1                     1.772       Not Collected         1         1

Arith. mean     1.772
Geom.  mean     1.772


I tried to attach before executing db2batch like
C:\work\Tuning\DB2\db2batch> db2 attach to linux0 user fs using fs

   Instance Attachment Information

 Instance server        = DB2/LINUX 8.1.3
 Authorization ID       = FS
 Local instance alias   = LINUX0

but it didn't help.

The same procedure works fine localy on the server generating stats
according to the PERF_DETAIL set.

Any idea?

Thanks
-Eugene



<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.