Advice needed on “DB2 DBA for Z/OS career”

5 pts.
Tags:
Database administration
IBM DB2
z/OS
Hello there,
I am a mainframe professional with over 6 years of experience. I worked mainly in IDMS database throughout my career. However, i am interested to learn database administration in DB2. I did clear initial DB2certification long back.
1>  To do DB2 DBA, how difficult is it for me as i am from IDMS back
      ground?
2>  What are the prerequisites for doing DB2 DBA?
3> Do i need expertise in JCL etc?
4>  Are there any good training institutes in Bangalore, India for DB2 DBA?
Your advise is appreciated.
Regards,
Prasanna


Software/Hardware used:
DB2 DBA for Z/OS

Answer Wiki

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

1) DB2 is quite different from IDMS.

2) You will need a good, solid basis in RDBMS theory.
You will need in depth DB2 knowledge.
You will need in depth z/OS (MVS) knowlege.
Have you ever used SQL? If you are going to be a DBA you need to know what the SQL does “under the covers.”
I good DBA is a blend of DB2 expert, systems programmer (because you will be installing DB2), systems analyst (because you will be working with the applications people), and a you need to be a drunk (so that you can sleep at night).

3) yes. ANYTHING on the mainframe requires JCL. And as a DBA you will be expected to be an expert in EVERYTHING.

4) I don’t know.

Book learning is a start.
SQL is SQL, but how it is used by DB2 is different than how it is used by Oracle or by SQL Slower. It is even different between DB2 on LUW and DB2 on z.

One does not start out at the top.
Maybe get a job as a DBA trainee to start.
Nothing can educate a person as well as hands on working with someone who knows.

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
  • HMSSL2K
    Get "hands on experience", learn and understand DB2, performance issues.
    3,175 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