QRECOVERY and SQL Packages

kylepyro

Active Member
We're observing sql packages growing at roughly the rate of 1 gig per hour of active use, mostly in QRECOVERY where they are supposed to go now. Needless to say this seems a little over the top for an install with about 200 users.

Q1. Is anyone else seeing this type of growth?

Q2. Does anyone know if the lib QRECOVERY needs to be in the lib list of jobd's or the system portion of the lib list.

Q3. If the answer to Q2 is no, how does the app determine where to look for a package?

confused.gif
 
Kyle,

This doesn't seem unreasonable to me. Remember EVERY SQL you process gets put in the package, until it reaches it's maximum size.

Even a small JDE installation will generate 1000's of SQL's per hour.

Q2 & Q3: When you set up the ODBC connection you tell the system where to put the package. Go to the ODBC data sources and select the 'packages' tab.

Hope this helps.

Tom
 
Back
Top