That is strange, but db2set fails to set DB2INSTANCE:
C:\Program Files\IBM\SQLLIB\BIN>db2set DB2INSTANCE=linux0
DBI1302E Invalid parameter detected.
Explanation:
An invalid parameter was used.
User Response:
Use the -? option for the usage help message.
Well... then I tried to reset DB2INSTDEF from the default, ie local
DB2, to the remote one on linux:
C:\Program Files\IBM\SQLLIB\BIN>db2set -all
[e] DB2PATH=C:\Program Files\IBM\SQLLIB
[i] DB2_CORRELATED_PREDICATES=TRUE
[i] DB2_HASH_JOIN=YES
[i] DB2ACCOUNTNAME=LIZARD\efiryago
[i] DB2INSTOWNER=LIZARD
[i] DB2PORTRANGE=60000:60003
[i] DB2_GRP_LOOKUP=LOCAL
[i] DB2INSTPROF=C:\PROGRA~1\IBM\SQLLIB
[i] DB2COMM=TCPIP
[g] DB2_DOCCDPATH=C:\Program Files\IBM\SQLLIB\
[g] DB2SYSTEM=LIZARD
[g] DB2PATH=C:\Program Files\IBM\SQLLIB
[g] DB2INSTDEF=DB2
[g] DB2ADMINSERVER=DB2DAS00
C:\Program Files\IBM\SQLLIB\BIN>db2set DB2INSTDEF=linux0
C:\Program Files\IBM\SQLLIB\BIN>db2set -all
[e] DB2PATH=C:\Program Files\IBM\SQLLIB
[i] DB2_CORRELATED_PREDICATES=TRUE
[i] DB2_HASH_JOIN=YES
[i] DB2ACCOUNTNAME=LIZARD\efiryago
[i] DB2INSTOWNER=LIZARD
[i] DB2PORTRANGE=60000:60003
[i] DB2_GRP_LOOKUP=LOCAL
[i] DB2INSTPROF=C:\PROGRA~1\IBM\SQLLIB
[i] DB2COMM=TCPIP
[g] DB2_DOCCDPATH=C:\Program Files\IBM\SQLLIB\
[g] DB2SYSTEM=LIZARD
[g] DB2PATH=C:\Program Files\IBM\SQLLIB
[g] DB2INSTDEF=LINUX0
[g] DB2ADMINSERVER=DB2DAS00
C:\work\Tuning\DB2\db2batch>db2 list db directory
System Database Directory
Number of entries in the directory = 8
....
Database 4 entry:
Database alias = OAKL0
Database name = OAKDB
Node name = LINUX0
Database release level = a.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
....
No any better:
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: 2.243 seconds
---------------------------------------------
Summary of Results
==================
Elapsed Agent CPU Rows Rows
Statement # Time (s) Time (s) Fetched
Printed
1 2.243 Not Collected 1 1
Arith. mean 2.243
Geom. mean 2.243
By the way, I've been told, db2batch from 8.1GA client on W2K works
fine against a remote database, bug in FP3?
-Eugene
"Mark A" <ma@switchboard.net> wrote in message news:<Gr*****************@news.uswest.net>...
"Eugene" <eu****@profitlogic.com> wrote in message
news:95**************************@posting.google.c om... I am trying to use db2batch from my XP client against a remote
database.
And here's what I am getting:
[snip]
The same procedure works fine localy on the server generating stats
according to the PERF_DETAIL set.
Any idea?
Thanks
-Eugene
Try changing the default DB2 instance. Issue the following command from your
XP command window:
db2set db2instance=new_value