Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does DB2 for i require a DBA?

April 26, 2017db2 DBA require

0

0 Posted

Does DB2 for i require a DBA?

1 Answer

0

0 Posted

Maybe! Again, a “traditional” DBA will spend more of their time with DB2 for i doing data modeling, SQL coding, developing indexing strategies, and SQL optimization. If the application is SQL based, this is a critical element to ensuring appropriate design and SQL optimization. A person with an understanding of SQL optimization is highly recommended to fully leverage the benefits of DB2 for i. But as traditionally defined, typical tasks required by other database systems will NOT be required due to the advanced architecture of IBM i. Many of the typical DBA tasks are handled automatically by the OS (data striping, collection of statistics for use by the SQL Optimizer, managing log or buffer space). For more details, refer to: ftp://ftp.software.ibm.com/systems/i/db2/pdf/acfaq.