IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and Windows is a certification that concentrates in the advanced concepts of DB2 administration. This certification not only needs knowledge on the basic level like creation, design and deployment but also on how to optimize and tune a database. Usually the optimization, security, tuning and maintain them without any problem is an important talent that should be known by every advanced user. Learning such a talent and skill is the key thing for attempting this certification and anyone will become an expert by practicing the same in a day to day work culture.
Who can do this certification
This certification becomes a mandatory knowledge repository for architects and technical persons who are well versed in database administration. This is the next level of the regular administration performed on a daily basis. The person must be able to maintain the DB2 products on various platforms like Windows, Solaris, AIX, UNIX, HP-UX and LINUX. The person should be capable enough to perform and support very high level tasks related to security, network, performance tuning and availability of the database at a high level. Before attempting this certification if it better that the exam topics are read and understood carefully and estimate if oneself is eligible in taking up the exam.
Person passing this exam would be a master in the advanced skill set of database administration and would be able to perform in various platforms as explained above. This makes you very productive and consistent enough in the work done such that you meet the requirement standards of your organization always. Thus, your customer and users are satisfied with the deliverables you provide and in turn you will be paid based on your performance. There was a recent study that the project delivery was more reliable when a person who is certified is doing the task.
This needs 3 exams to be passed to gain certification.
- Either C2090-610 or C2090-730
- C2090-614 - DB2 10.1 Advanced DBA for Linux UNIX and Windows
So you definitely require a prominent understanding in the administrator role that is very advanced. You may opt to attend a number of courses listed which are not mandatory but highly recommended. These courses will teach you how to perform the administration tasks, functions and new characteristics of the DB2 database and their technical information. They also teach you about the old versions and releases of database. It teaches you on how to optimize the performance and partitioning the different environments. By doing all these courses you get to know in details about every concept which will help you. Therefore it is very good to check the eligibility by checking the topics covered in the exam.
IBM Certified Advanced DataBase Administrator - DB2 10.1 for Linux UNIX and Windows exam has the below topics to be covered extensively.
- Extensive knowledge in creation, designing and managing table spaces, storage paths, buffers of a database.
- Concepts of using the data studio
- Designing, creating and managing the clustered tables that are multi-dimensional, partitioning, and table clusters.
- Knowledge on recovering a database using logs, backing up the database, HADR, finding suitable tool for diagnosis and WLM.
- Should know the concepts pertaining to Optimization of the query, parallelism, solving performance issues, database tuning and compression techniques.
- Extensive and deep understanding on the pureScale, Replication and Audit
This exam will assess your capability in the advanced concepts of administering a DB2 10.1 database and you will gain an extensive knowledge on how to overcome the problems raised in your organization.
Out of the given 54 questions it is required that 33 questions should be right which approximately is 60%. Total time that would be given to complete the multiple choice format exam would be 1 and half hours. English is the only language in which the exam could be attempted.
Validity of the Certification
Certification provided by IBM usually will not expire. The exams might have to be done again as in when there is an update in the version of the technology. This would help you to be on par with the standards of technology and keep going in this highly competitive world.
This certification thought me about every nook and corner on how to administer and monitor a database. I was able to do my tasks effectively and efficiently after taking up this hard certification. I would suggest people to take this certification only if you are having a serious career path towards the DB2 administration since it has many in depth concepts to be covered.
Kevin John, Ruggedcom Inc