E1: DB: OS: AS400 iSeries SQL Packages Frequently Asked Questions and Answers
(Doc ID 1602140.1)
Last updated on FEBRUARY 21, 2025
Applies to:
JD Edwards EnterpriseOne Tools - Version SP24 and laterIBM i on POWER Systems
Purpose
Frequently Asked Questions about AS400 iSeries SQL Packages. This document complements information found in <Document 1525639.1> - E1: OS: Overview, Maintenance and Known Issues for AS400 SQLPkgs.
Questions and Answers
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Questions and Answers |
| Q: What are SQL packages? |
| Q: When do SQL packages get created? |
| Q: How are SQL packages named? |
| Q: What library does the SQL package go into? Is there a preferred library for SQL packages? |
| Q: What are the advantages of using SQL packages? |
| Q: Do all prepared statements go into an SQL package? |
| Q: How can I tell what statements are in an SQL package? |
| Q: Can the same statement appear multiple times in the same SQL package? |
| Q: How can I tell if the SQL package is being used? |
| Q: What data is stored in an SQL package? |
| Q: How big is an SQL package? |
| Q: Are there any performance considerations for the new, bigger packages? |
| Q: Is there an optimal size for bigger packages? |
| Q: Are there any plans to support bigger packages in releases prior to V4R3? |
| Q: What happens when SQL packages get full? |
| Q: Are there other times when an SQL package can become unusable? |
| Q: When should I delete SQL packages? |
| Q: How do I delete SQL packages? |
| Q: Why would service personnel recommend deleting SQL packages? Are they corrupted? |
| Q: Why can't I delete a package with a name of _CSETUP (or other nonstandard system object names)? |
| Q: What are the QSQLPKG and QSQXDPKG packages in QSYS for? Can they be deleted? |
| References |