That is strange, but db2set fails to set DB2INSTANCE:
C:\Program Files\IBM\SQLLI B\BIN>db2set DB2INSTANCE=lin ux0
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\SQLLI B\BIN>db2set -all
[e] DB2PATH=C:\Prog ram Files\IBM\SQLLI B
[i] DB2_CORRELATED_ PREDICATES=TRUE
[i] DB2_HASH_JOIN=Y ES
[i] DB2ACCOUNTNAME= LIZARD\efiryago
[i] DB2INSTOWNER=LI ZARD
[i] DB2PORTRANGE=60 000:60003
[i] DB2_GRP_LOOKUP= LOCAL
[i] DB2INSTPROF=C:\ PROGRA~1\IBM\SQ LLIB
[i] DB2COMM=TCPIP
[g] DB2_DOCCDPATH=C :\Program Files\IBM\SQLLI B\
[g] DB2SYSTEM=LIZAR D
[g] DB2PATH=C:\Prog ram Files\IBM\SQLLI B
[g] DB2INSTDEF=DB2
[g] DB2ADMINSERVER= DB2DAS00
C:\Program Files\IBM\SQLLI B\BIN>db2set DB2INSTDEF=linu x0
C:\Program Files\IBM\SQLLI B\BIN>db2set -all
[e] DB2PATH=C:\Prog ram Files\IBM\SQLLI B
[i] DB2_CORRELATED_ PREDICATES=TRUE
[i] DB2_HASH_JOIN=Y ES
[i] DB2ACCOUNTNAME= LIZARD\efiryago
[i] DB2INSTOWNER=LI ZARD
[i] DB2PORTRANGE=60 000:60003
[i] DB2_GRP_LOOKUP= LOCAL
[i] DB2INSTPROF=C:\ PROGRA~1\IBM\SQ LLIB
[i] DB2COMM=TCPIP
[g] DB2_DOCCDPATH=C :\Program Files\IBM\SQLLI B\
[g] DB2SYSTEM=LIZAR D
[g] DB2PATH=C:\Prog ram Files\IBM\SQLLI B
[g] DB2INSTDEF=LINU X0
[g] DB2ADMINSERVER= DB2DAS00
C:\work\Tuning\ DB2\db2batch>db 2 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>db 2batch -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****@profitl ogic.com> wrote in message
news:95******** *************** ***@posting.goo gle.com... 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