We have an iSeries model 820/2436/1525 with interactive features, partitioned two ways and running OS/400 V5R1 on both. We are exploring SQL/400 for our applications. Is it possible to make SQL/400 program(s) run in a batch environment? Right now the SQL programs created by our programmers consume 35% interactive CPU.
There's no way to have SQL run in batch without changing your design so that the programs containing the embedded SQL run in batch. You may want to do some SQL performance analysis to verify that the SQL is being executed in the most efficient manner (e.g., Do you have the right indexing strategy in place?). There are some SQL performance materials online here.
MORE INFORMATION ON THIS TOPIC
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.
Dig Deeper on DB2 UDB (universal databases)
Related Q&A from Kent Milligan
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading
When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.