Info needed on QZDAOSINIT jobs

pts.
Tags:
DataCenter
Francois wrote in with this question recently: I'm doing performance analysis on iSeries Mdl 525 running V5R2. The application is JDE One World General Ledger. I've noticed seize and lock occurrences in the performance data. Closer performance trace analysis revealed that QZDAOSINIT jobs were locking objects requested by QDBSRVnn jobs. The objects being locked are indicated by an address only (i.e. no object name library or type.) Francois wonders what the QDBSRVnn tasks do. Also, what the relationship is between QZDAOSINIT jobs and QDBSRVnn tasks. And why the locked objects are shown as addresses only and not by name, library and type. Can you answer his questions? -- Deb Tart, associate editor

Answer Wiki

Thanks. We'll let you know when a new response is added.

From what I know, the QDBSRVxx-jobs are mainly for maintaining the DB2 repository and data dictionary. As soon as you create/restore/alter something that’s of type file, you will find activity in these jobs. They take care of the content of files in lib QSYS2. QZDASOINIT-jobs are for client-server requests against the i5. So, if a client issues a “ALTER TABLE” sql, this will also trigger QDBSRV-jobs to take action. In some cases it takes some time for them to finish work. Since they run async with other jobs, you can discover a lock status. Another thing worth to look at is the async maintanence of existing accesspaths (LFs) the SQL-optimizer decides to use for a sql. Remember: LFs can be marked for MAINT(*DLY or *REBLD).

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following