IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 - Certification - Everything you need to Know


IBM Mainframe Forums -> DB2
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
skqwee

New User


Joined: 24 Mar 2005
Posts: 2

PostPosted: Thu Apr 21, 2005 1:39 pm
Reply with quote

Hello,

Could someone tell me the process of taking the IBM DB2 certification
Back to top
View user's profile Send private message
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1210
Location: India

PostPosted: Fri Apr 22, 2005 9:59 pm
Reply with quote

Available IBM Certifications:
www-03.ibm.com/certify/certs/dm_index.shtml

IBM Test Information:
www-03.ibm.com/certify/tests/test_index.shtml

Popular DB2 Tests

Quote:
512 - DB2 UDB V7.1 Family Fundamentals
514 - DB2 UDB V7.1 Family Application Development
516 - DB2 UDB V7.1 for OS/390 Database Administration

700 - DB2 UDB V8.1 Family Fundamentals
701 DB2 UDB V8.1for Linux, UNIX and Windows Database Administration
702 DB2 UDB V8.1 for z/OS Database Administration
703 DB2 UDB V8.1 Family Application Development
705 DB2 Business Intelligence Solutions V8.1
706 DB2 UDB V8.1 for Linux, UNIX and Windows Database Administration Upgrade exam
442 DB2 Content Manager V8


Exam 512 & 514 Guidelines:
Code:
http://www-03.ibm.com/certify/certs/dbseudd7.shtml
http://www-03.ibm.com/certify/tests/obj512.shtml
http://www-1.ibm.com/certify/tests/sam512.shtml
http://www-03.ibm.com/certify/tests/obj514.shtml



Exam 700 Guidelines:

Code:
http://www-03.ibm.com/certify/tests/obj700.shtml
http://www-03.ibm.com/certify/tests/edu700.shtml
http://www-106.ibm.com/developerworks/db2/library/tutorials/db2cert/db2cert_tut.html
http://www-128.ibm.com/developerworks/db2/library/tutorials/db2cert/db2cert_V8_tut.html
http://www-306.ibm.com/software/data/education/pdfs/exam-700.pdf


Exam 701 Guidelines:
www-128.ibm.com/developerworks/db2/library/tutorials/db2cert/701_prep.html


Exam 702 Guidelines:

Code:
http://www-03.ibm.com/certify/tests/obj702.shtml
http://www-03.ibm.com/certify/tests/edu702.shtml

Exam 703 :
www-128.ibm.com/developerworks/offers/lp/db2cert/


Certification Tutorials:

www-106.ibm.com/developerworks/db2/library/tutorials/db2cert/db2cert_tut.html

www-106.ibm.com/developerworks/db2/library/tutorials/db2cert/db2cert_V8_tut.html

www-306.ibm.com/software/data/education/pdfs/exam-700.pdf


Recommended Books:


btobsearch.barnesandnoble.com/booksearch/isbninquiry.asp?ISBN=0131424653&pdf=y&userid=2VO7FE16Q1&sourceid=0039356948&btob=Y

btobsearch.barnesandnoble.com/booksearch/isbninquiry.asp?userid=2VO7FE16Q1&sourceid=0039356948&btob=Y&pwb=1&ean=9780672325823


btobsearch.barnesandnoble.com/booksearch/isbninquiry.asp?userid=2VO7FE16Q1&sourceid=0039356948&btob=Y&pwb=1&ean=9780130463913

btobsearch.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=P21KuxKBJt&sourceid=0039356948&btob=Y&isbn=0072133759&itm=5

www.murach.com/books/db1r/index.htm

www.murach.com/books/db2r/index.htm

More Info

ibmmainframes.com/viewtopic.php?t=2214&highlight=db2+certification

ibmmainframes.com/viewtopic.php?t=2207&highlight=db2+exam+certification

ibmmainframes.com/viewtopic.php?t=129&highlight=db2+exam+certification

ibmmainframes.com/viewtopic.php?t=391&highlight=db2+exam+certification

DB2 - Certification - Everything you need to Know
www-106.ibm.com/developerworks/db2/library/techarticle/0207fosdick/0207fosdick.html
Back to top
View user's profile Send private message
skqwee

New User


Joined: 24 Mar 2005
Posts: 2

PostPosted: Fri Apr 22, 2005 10:24 pm
Reply with quote

Hello there,

Thanks for the info on the exams. I am currently residing in London and I would like to know how much would I have to pay to take the test 512 and 514...Will it be possible for me to take the test on-line..or do I have to take it at a specific exam centre...If so, please give me the centres that i could go register to for these tests.

Thanks in advance
Back to top
View user's profile Send private message
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1210
Location: India

PostPosted: Sat Apr 23, 2005 7:22 am
Reply with quote

Sorry, No Idea about London.. But for Indians, this is the contact detail:

IBM Training Services
IBM India Limited
#12 subramanya Arcade,
Bannergatta Road.
Bangalore - 560 029
Phone: 91 - 80 - 2063000/6787202
Fax : 91 - 80 - 2063109


If you have any queries regarding the career programs or IT Awareness Courses courses, email aceinfo@in.ibm.com.

If you have any queries regarding the corporate training programs email corpedu@in.ibm.com.

But you can write the exams in IBM authorized Training Centres...

I prefer you to choose NIIT:

www.itpeopleindia.com/20020930/careers2.shtml

Check this link for Pearson Vue Test centres:

www.vue.com/ibm/centers/
Back to top
View user's profile Send private message
brganeshbabu

New User


Joined: 23 Jun 2005
Posts: 34
Location: Chennai

PostPosted: Tue Jun 28, 2005 12:49 pm
Reply with quote

Additionally you have to write 703 exam(along with 700) to become an IBM certified Application Developer. This is for 8.1 family. Check this link available below.
Code:
http://www-03.ibm.com/certify/certs/dbapudv81.shtml
Back to top
View user's profile Send private message
gandhire

New User


Joined: 23 Oct 2004
Posts: 5

PostPosted: Thu Jul 21, 2005 9:59 pm
Reply with quote

IBM offers a series of six free interactive online tutorials that prepare you for exam 700, downloadable from www7b.software.ibm.com/dmdd/trainingcertification.html, or directly from www7b.software.ibm.com/dmdd/library/tutorials/db2cert/db2cert_V8_tut.html. These are great background if you?re new to DB2.

It is essential that you take ?practice tests,? mock-ups of the real thing with similar questions. You need to be test-ready. IBM offers a free online test for each certification exam. Take any of them via the web from www7b.software.ibm.com/dmdd/trainingcertification.html or certify.torolab.ibm.com/ice/displayPage/en. You must have Internet Explorer 5 or above or Netscape Communicator 4.7 or above to take these practice exams. The other source for practice questions are the certification books by Roger Sanders.
Back to top
View user's profile Send private message
vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Thu Jul 21, 2005 10:58 pm
Reply with quote

This info was pasred earlier i have just copied it

Below is the information you have requested for...

IBM DB2 CERTIFICATION TEST 512

A] SOME IMPORTANT LINKS:
1. Basic test information:
[url]http://www-1.ibm.com/certify/tests/info.shtml#512 [/url]
2. Syllabus:
[url]http://www-1.ibm.com/certify/tests/obj512.shtml [/url]
3. Sample test:
[url]http://www-1.ibm.com/certify/tests/sam512.shtml [/url]


As per my opinion, time required for preparation is as follows:

1. First reading of reference book ? 15 days.
2. Clearing free voucher test ? 2-3 days
3. Practice and revision ? 7 days

C] VOUCHER TEST / SAMPLE TEST:

1. A sample test is available on IBM site for preparation of IBM DB2 certification (refer link A3). This test is conducted on internet.

2. There is a free voucher scheme available for this certification. This means that if you score more than 75% marks in the sample test, you can appear for the IBM certification test free of cost.

3. You can appear for this sample test as many times as you wish. Once you score 75% + marks, IBM will send you a voucher number through email.

4. When you register for main certification exam, you have to give this voucher number.

5. For taking this sample test you have to register on the IBM site. Link no A3 mentioned above will lead to registration page.

6. The sample test is very easy as compared to main exam and most of the times you can score 75% easily. Thus it is advisable to appear for sample test first and then for main exam as in that case you won?t have to pay any money for main exam.

D] BOOKS AND RESOURCES USED:

1. For preliminary preparation I used following book:
?DB2 Universal Database V7.1 for UNIX, Linux, Windows and OS/2 DBA Certification? -by Baklarz and Wong

Quote:
Above book contain 16 chapters out of which only first 8 chapters are applicable for IBM test 512. Rests of the chapters are for test 513. Total number of pages to be read is about 400.


This book discusses all theoretical aspects in detail and gives practical examples. Many conceptual questions in IBM exam are discussed in this book.

My experience is that 15 days are sufficient to read this book thoroughly.

2. For a last day revision, I used free IBM tutorial (link 4 mentioned above) which was very useful. But it does not have any practical examples and for first round of study, it should not be used.

3. Other than these 2 resources, some other books are also available on AMAZON for DB2 test 512 preparation. I did not use them.

4. There is a CBT available on IBM site. But I feel that it is of very basic nature and does not help in preparing for the test.

E] ABOUT MAIN IBM TEST

1. IBM test is conducted in IBM authorized centers only. There is one IBM center at Nigadi.
2. You have to register for the exam at least 2 days in advance.
3. There are 55 questions and you have 75 minutes to answer them.
4. Passing score is 55%.
5. You can change the answers at any point of time during the exam.
6. Main IBM test covers questions from all topics and equal weightage is given to theory questions and practical problems.
7. Some of the important topics which had high weightage when I appeared for the test are as follows:

Locking and Isolation levels ? 8 questions
Commit and Rollback concepts ? 5 questions
SQL ? 10 questions
Creation of databases ? 7-8 questions

Hope this helps


Regards

Mayuresh Tendulkar
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 677
Location: NJ

PostPosted: Wed Dec 07, 2005 3:17 pm
Reply with quote

Hi shilpa palasam,

The certification that u had completed is a good thing in mainframe.. and now the next step is to get specialization in one area.. Eg: in Database.. so DB2 certification is worth.. search for more about that in this forum and get benefited...
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 677
Location: NJ

PostPosted: Wed Dec 07, 2005 3:19 pm
Reply with quote

Hi venky5436 & Tara,

Plz Search some previous forum regarding the Certification.. Go in DB2 Area and search for ur need. hope helpful..
Back to top
View user's profile Send private message
shilpa palasam

New User


Joined: 06 Dec 2005
Posts: 1
Location: hyderabad

PostPosted: Thu Dec 08, 2005 1:48 pm
Reply with quote

hi khamarutheen,

thanx for ur help. i have gone thr' the site.i found that i should give 3-4 certifications to complete the certification.means i found it as in the first step ,i need to pass one certfn.in the step there are three exams.

is it required to complete all the 3 steps of certifications for the certification in db2.

shilpa.
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 677
Location: NJ

PostPosted: Thu Dec 08, 2005 2:27 pm
Reply with quote

Hi frnd,
First U need to get trhu the Exam 700.. then according to ur specialization u can select the next level of the exam. it's up to u. but the first is basic and fundamentals..All the best.. prepare it well and do a sample test and then go for the final one..
Back to top
View user's profile Send private message
tomrsan

New User


Joined: 15 Oct 2005
Posts: 13
Location: chennai

PostPosted: Thu Dec 08, 2005 4:46 pm
Reply with quote

hi kam

where i have to approach for the exam , where i have to apply 4 this,where i can get the detailed and date of the exam
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 677
Location: NJ

PostPosted: Thu Dec 08, 2005 6:11 pm
Reply with quote

Hi santhosh,
Use this following link

Code:
http://www-128.ibm.com/developerworks/db2/library/tutorials/db2cert/db2cert_V8_tut.html


Code:
http://www-03.ibm.com/certify/tests/sam700.shtml


Hope helpfull..
Back to top
View user's profile Send private message
venky5436

New User


Joined: 06 Dec 2005
Posts: 12

PostPosted: Sat Dec 10, 2005 1:30 am
Reply with quote

Hi Khamarutheen,

Thanx for your response. I have seen those previous posts and came across the Q&A which Priya has provided on the site itportal.org.Thanx a lot to PRIYA as I was looking for this for a long time.I wanted to know is this the only material available for the DB2 UDB 701 Certification.I was looking for some Sample tests which will help me prepare for the 701 Certification.I would be very greatful to you as this will help many who are looking to take the certification.IBM and Selftestsoftware have stopped providing them.IBM provides them but they charge $10 for each test even if it is the same test you have bought before .So it is risky to buy.

Thanx again.

Venky
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 677
Location: NJ

PostPosted: Wed Dec 14, 2005 12:10 pm
Reply with quote

Hi jeyaraj,,

Plz search in the below link and get the details...
Code:

http://www-03.ibm.com/certify/tests/test_index.shtml

And search the previous post in the forum priya has posted an attachment regarding that... check it..
Back to top
View user's profile Send private message
jonna

New User


Joined: 18 Apr 2005
Posts: 9

PostPosted: Fri Sep 15, 2006 10:29 am
Reply with quote

Hi all,
Is it possible to write 703 DB2 certification with out 700 DB2 certification or preliminary exams?
Thanks in advance..
Back to top
View user's profile Send private message
subhasis_50

Moderator


Joined: 09 Mar 2005
Posts: 363
Location: Earth

PostPosted: Tue Sep 19, 2006 5:01 pm
Reply with quote

Hi,
I have one study materials for DB2 700 exams. If anybody wants it, pm your mail id. This book is sufficient for taking the exam.
Back to top
View user's profile Send private message
babu_hi

New User


Joined: 11 Apr 2006
Posts: 93

PostPosted: Mon Nov 13, 2006 12:44 pm
Reply with quote

Hi to all,

The Price for 700 - DB2 UDB V8.1 Family Fundamentals certification is
30 USD($) or around 1410 INR(Rupees).
Back to top
View user's profile Send private message
Ramanarayanan
Warnings : 1

New User


Joined: 05 Jan 2007
Posts: 1
Location: Chennai

PostPosted: Wed Jan 31, 2007 3:08 pm
Reply with quote

Hi to all,
Where can we take the exam and where to register?
Back to top
View user's profile Send private message
Bharti P Manglani

New User


Joined: 13 Mar 2007
Posts: 16
Location: Pune

PostPosted: Thu Jul 19, 2007 1:40 pm
Reply with quote

Hi,

I would like to ask whether I would be requiring to install DB2 on my machine to prepare for the test?

If so from where can I install it icon_question.gif

Thanks in advance.
Back to top
View user's profile Send private message
Sarva_bubli

New User


Joined: 09 Aug 2006
Posts: 37
Location: Pune, India

PostPosted: Fri Oct 26, 2007 3:05 pm
Reply with quote

Hi,
I got the certification in DB2 Exam 700. Now I am dilemma, as which stream to go either development or DBA. Please suggest me about the opportunities available for these streams.
As far as my knowledge is concerned, if I choose DBA I need to write the 702 and for developer 703.
Many Thanks.
Back to top
View user's profile Send private message
Midhila Menon

New User


Joined: 10 Oct 2007
Posts: 4
Location: Bangalore

PostPosted: Mon Oct 29, 2007 1:33 pm
Reply with quote

Hi,

I have taken DB2 Exam 700 just recently.Iam planning to take DB2 Exam 703 next.
Can anyone help me in this regard. Does DB2 Exam 703 requires a deep knowledge of Java.Actually while referring material I came across Java.Please help with this query.
Can anyone send the required link for Sample question papers to refer.
Thanks.....
Midhila
Back to top
View user's profile Send private message
vasanthkumarhb

Active User


Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex

PostPosted: Wed Nov 28, 2007 12:35 pm
Reply with quote

hi,

Quote:
would like to ask whether I would be requiring to install DB2 on my machine to prepare for the test?


for above scenario u can download free software from the net and learn how to create Table and all the properties of the table in windows format, it is available in IBM site.



Sarva_bubli wrote:
Hi,
I got the certification in DB2 Exam 700. Now I am dilemma, as which stream to go either development or DBA. Please suggest me about the opportunities available for these streams.
As far as my knowledge is concerned, if I choose DBA I need to write the 702 and for developer 703.
Many Thanks.


It is depends on your interest if u are very well in DBA(ADMIN) get in to that, or else stay back with development.

Quote:
where i have to approach for the exam , where i have to apply 4 this,where i can get the detailed and date of the exam


Hi you can search for Thompson Prometric centre in ur place or else nearby city that u belong to an just catch the centre, that's all.
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India

PostPosted: Wed Nov 28, 2007 12:41 pm
Reply with quote

In addition to Vasanth's suggestion -

Quote:
for Thompson Prometric centre in ur place or else nearby city that u belong to an just catch the centre


Some companies (stress on some & if you are working) had tied up with the prometric centre for taking certitication exams in their campuses it self.

If you are lucky enough and working in those companies, no need to search for any centres.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts User access certification In Mainfram... All Other Mainframe Topics 4
No new posts DB2 fundamentals certification DB2 5
No new posts DB2 certification DB2 3
No new posts MQ Solution Designer Certification IBM Tools 0
No new posts What is DB2 certification for 5 years... DB2 3
Search our Forums:

Back to Top