ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Using JDBC from Unix to pull data from iSeries

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Using JDBC from Unix to pull data from iSeries

    Intriguing situation here... I have a program on a Unix box that performs the following:

    PHP Code:
    Select F1F2... Fx
       From LIB
    .Table
      Where StoreNo 
    = <StoreNo
    This is basically a pointer to the data once it is run.

    Program then does:

    PHP Code:
    Insert into 
       DBUser
    .Table 
       
    (F1F2, ... Fx)
    Values
       
    (?, ?, ... ?) 
    The data set retrieved is about 48k records. When running this for 1 store, the job runs and completes in about 3 minutes (There are 5 different data sets it pulls to update Derby Database Tables)

    The Lib.Table is indexed on StoreNo as the Primary Key.

    When I run 15 of these jobs concurrently, it takes over 30 minutes to complete all 15. Which seems to point back to the JDBC pulling data. Could the be due to the index on the table? Or, is there a Share Access Path that I'm missing here?

    Let me know
Working...
X