WinPrice
Active Member
For EnterpriseOne 9.0, I have a customer that I am in the planning stage for running a test on to determine the performance impact of turning off SQLPKG use by E1. This particular customer has no end of issues with SQLPKGs. They have a lot of outside connections into the AS/400, so I suspect one of these other connections is creating SQL statements that are going into the SQLPKGs in a format that E1 has problems with, resulting in SQLPKGs needing to be deleted on a frequent basis. Not a great solution if this needs to be done in the middle of the day during the week.
For fat clients (including DSI, which this customer uses), you can turn these off in each ODBC configured to connect to the AS/400 for JDE Data Sources by unchecking the box "Enable extended/dynamic package support), according to Doc ID: 1525639.1)
For web client connections, you will need to comment out the as400PackageLibrary=QRECOVERY line from the JDBJ.ini file under [JDBj-RUNTIME PROPERTIES] section. From what I read on Doc ID: 2588441.1, if this doesn't work, you will also need to turn of SQL caching by setting as400ExtendedDynamic=false in JDBJ.ini under the [JDBj-RUNTIME PROPERTIES] section. I plan to just do both.
The last piece I need is whether you can turn of SQLPKG use on the AS/400 itself, as when UBEs are launched on the server, or when processes running locally on the AS/400 are using SQLPKGs to query/update/delete data from the database there. For kernels, UBEs, and TCs, the "SQL PACKAGE LIBRARY" setting is set to 1, but I do not believe there is a way to turn these off completely, so we can gather data on this piece during our test. Are any of you aware of a way to do this?
For fat clients (including DSI, which this customer uses), you can turn these off in each ODBC configured to connect to the AS/400 for JDE Data Sources by unchecking the box "Enable extended/dynamic package support), according to Doc ID: 1525639.1)
For web client connections, you will need to comment out the as400PackageLibrary=QRECOVERY line from the JDBJ.ini file under [JDBj-RUNTIME PROPERTIES] section. From what I read on Doc ID: 2588441.1, if this doesn't work, you will also need to turn of SQL caching by setting as400ExtendedDynamic=false in JDBJ.ini under the [JDBj-RUNTIME PROPERTIES] section. I plan to just do both.
The last piece I need is whether you can turn of SQLPKG use on the AS/400 itself, as when UBEs are launched on the server, or when processes running locally on the AS/400 are using SQLPKGs to query/update/delete data from the database there. For kernels, UBEs, and TCs, the "SQL PACKAGE LIBRARY" setting is set to 1, but I do not believe there is a way to turn these off completely, so we can gather data on this piece during our test. Are any of you aware of a way to do this?