Responsibilities of DB2/400

1675 pts.
AS/400 database
AS/400 DB2
IBM iSeries

Being an AS/400 development/admin guy what are the roles and responsibilites of DB2/400(DB/400 ?) on daily basis.

 What could be the  maintenance activities.

I'm just curious about to know...waiting for your valuable comments..



Software/Hardware used:
AS/400,DB/400 ,iSeries,

Answer Wiki

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

Try this site…

Discuss This Question: 2  Replies

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.
  • Lovemyi
    Actually the DBA roles and responsiblities are a lot less on the IBM i platform than any other in the world as the system manages all DBA tasks like moving database files, sizing them, resyncronizing indexes, etc. These tasks are all part of the i5OS and are automatic due to single level storage and being intergrated into the OS. The manual tasks are creating new indexes and even then IBM gives you guidence on what indexes you should create. Adding fields to tables/files are other taksks. Most shops do not need even a part time DBA. Only the larger shops that need to create new indexes on a regular basis for perfromance reasons. Even these tasks can and should be handled by the programmers when they code a new application. Lovemyi
    2,310 pointsBadges:
  • TomLiotta
    The link in the answer box has a few articles that discuss general concepts such as 'Good Database Design', but those are just about the only articles that have relevance to DB2/400 (DB2 UDB for iSeries, or for System i). None of the other DB2 articles have relevance; and the articles about SQL Server, MySQL, Oracle, etc., are way out of scope. For most AS/400 sites, there is no such position as a DB2 Admin. There is no ongoing maintenance, no daily nor even regular/periodic duties. But for a fairly small fraction of sites, for the very large or the very sophisticated sites, DB2 Admins might do much of the database design and maintenance. In most sites, DB2 is mostly handled simply by the application developers for their application area. Once the tables/views/indexes are defined and created, there is almost nothing done to "maintain" them. In many sites, it's all done with 'native' database functions with little or no actual SQL nor SQL objects. DB2 is not a separate product in the AS/400 line. It is fully integrated with and inseparable from the operating system. The OS itself relies on it. Program development, communications, security -- everything a developer might do is integrated along with DB2. Because of that, a lot of extra pieces of DB2 that you might find on other platforms are not exposed or are not necessary. It is a very different environment. Tom
    125,585 pointsBadges:

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.

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


Share this item with your network: