Foreign Table problem

[SMMM]

Hi,

I had a Table Conversion program which reads Item data from an AS/400 file (Foreign Table) to load F4101Z1table.

When I run the program locally it load the data with in 2 minutes. When I run the same program in the server, it took almost 12 minutes. From the AS/400 JDEDEBUG trace file I found that it is taking 5 minutes to open each foreign table. I could not understand why it is taking long time to open the files. Thanks for any help.

The following is the part of Trace output from the AS/400 server.

Nov 12 14:52:46 ** Opening table FCV080, for input.
Nov 12 14:52:46 ** Entering JDB_OpenForeignTable(Table Name=FCV080)
Nov 12 14:57:18 ** Entering JDB_SetRequestOptions (Option No = 17 , Setting = 0)
Nov 12 14:57:18 ** Entering JDB_GetDSName.
Nov 12 14:57:18 ** Exiting JDB_GetDSName With Success
Nov 12 14:57:19 ** Input FCV080 is using data source Business Data - TEST.
Nov 12 14:57:19 ** Opening table F4101Z1, for output.
Nov 12 14:57:19 ** Entering JDB_OpenTable( Table = F4101Z1)
Nov 12 14:57:19 ** TAMInitX: (/DV7333/specfile/glbltbl.xdb) (/DV7333/specfile/gl
Nov 12 14:57:19 ** Called from [/B7334SYS/jdekrnl/jdb/jdb_rst.c] line 191
Nov 12 14:57:19 ** File will be closed: TRUE (/DV7333/specfile/glbltbl.xdb)
Nov 12 14:57:21 ** TAM_SUCCESS: pTam=SPP:0000 :1aefRS5830001 JDETECH 553954
Nov 12 14:57:21 ** TAMFetchByKey(SPP:0000 :1aefRS5830001 JDETECH 553954 :68049
Nov 12 14:57:21 ** OpenStates 1 of 1: pTam=SPP:0000 :1aefRS5830001 JDETECH
Nov 12 14:57:21 ** File will be closed: TRUE (/DV7333/specfile/glbltbl.xdb)
Nov 12 14:57:21 ** TAM_SUCCESS: Index id 1 - Current Key: - {"F4101Z1" 1 } -
Nov 12 14:57:22 ** TAMTerminate(SPP:0000 :1aefRS5830001 JDETECH 553954 :680490
Nov 12 14:57:22 ** Locking /DV7333/specfile/gbrlink.ddb in READ mode.
Nov 12 14:57:22 ** LOCK: Total READ locks after operation: 1
Nov 12 14:57:22 ** TAMInitX: (/DV7333/specfile/gbrlink.xdb) (/DV7333/specfile/gb
Nov 12 14:57:22 ** Called from [/B7334SYS/jdekrnl/jdb/jdb_trig.c] line 499
Nov 12 14:57:22 ** TAM_SUCCESS: pTam=SPP:0000 :1aefRS5830001 JDETECH 553954
Nov 12 14:57:22 ** TAMSetBeforeKey(SPP:0000 :1aefRS5830001 JDETECH 553954 :687
Nov 12 14:57:22 ** TAM_SUCCESS: Index id 2 - Current Key: - Before {4 "F4101Z