A DBA is required for the big iSeries server

pts.
Tags:
IBM DB2
Search400.com member Fred wrote in with this statement recently: "Despite what IBM marketings says, I think that a DBA is required for the big iSeries servers." Do you agree or disagree?" -- Debra Tart, associate editor, Search400.com

Answer Wiki

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

Search400.com member “JohnDavid” responds:

I have worked in some large AS/400 organizations with huge DB infrastructures and they appointed a specific person to manage their data bases:

1. Definition of tables and view
2. Referential integrity
3. Trigger programs
4. Changes to such definitions
5. Journals
6. Queries on journals
7. Monitor programs to identify specific journals
8. Optimization of data base
9. Re-orgs
10. Etc., etc.

We found that when several people do these tasks it becomes disjointed and eventually noone wants to assume responsibly.

So much for large databases. For small organizations one person can most probably perform several tasks of which DBA will be one, but I still think that such a function is critical.

Best regards

JohnDavid

Discuss This Question: 1  Reply

 
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
  • TheQuigs
    Sound application development could be said to require the capability of a Database Architect -- especially in developing, implementing, and maintaining a large system. However, I believe IBMs marketing line about not requiring a Database Administrator holds a lot of weight. Many of the typical DBA duties are not required on iSeries. The tasks listed by JohnDavid could all be handled by the developer/analyst. In large system development you need more developers on the project and perhaps you need some specialization including in the catagories listed, but the basic adminstration of the database is autmated (or at least *GREATLY* eased by OS/400). I think IBMs point is there isn't a need for a pure DBA. *System* adminstration is still required (backup, security, et al), but it's not as big a job as for other platforms.
    0 pointsBadges:
    report

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