Results 1 to 9 of 9

Thread: Db2 luw dba

  1. #1
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369

    Unanswered: Db2 luw dba

    As a DB2 LUW DBA, are you responsible for creating stored procedures / UDFs, binding packages... or is this a developer's job? How much do you need to know about things such as JDBC, CLI...?
    Last edited by db2girl; 07-17-10 at 23:02.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by db2girl
    are you responsible for creating stored procedures / UDFs, binding packages
    If you are a production DBA - not likely.

    If you are a development DBA - likely.

    Quote Originally Posted by db2girl
    How much do you need to know about things such as JDBC, CLI
    You don't need to, strictly speaking, but if you do you may benefit from it one day.

  3. #3
    Join Date
    Dec 2008
    Posts
    44
    yes, I am responsible for creating stored procedures / UDFs, binding packages in production environment...but, developer or development DBA creates them in dev, test systems..Dev DBA sends me the code and I execute them in prod.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    We had development DBAs and production support people (they were not really called DBAs) - mainframe shop.

    I've heard there are now different types of DBA for DB2 LUW - application DBA, system DBA, operational DBA... Do you have something similar at your organization? If you do, what is their role? To me, application DBA sounds more like a development DBA and system/operational DBA is more like a production DBA.

  5. #5
    Join Date
    Jan 2009
    Location
    United Kingdom
    Posts
    77
    Application developers who are intersecting with databases should have a firm grasp of stored procedures , indices etc , and be able to develop with a view to optimising data retrieval. They should work in conjunction with Production\Development DBA

  6. #6
    Join Date
    Jun 2009
    Posts
    272
    Bella, our organization has the concept of application dbas and operational dbas. Application dba is responsible for all devolopment stuff which includes writing stored procedures, udfs, etc... while operational dbas are responsible for production support.

    Duties: For creating the databases application dbas needs to provide the number of tablespaces and their sizes to operational DBA team. Based on that we, operational/production dbas will work with AIX and SAN team for creating databases. operational dbas are responsbile for creating all the test, qa and production databases. Application DBAS are typically given dbadm for test databases so that they can execute DDL such as creating tables, views indexes, stored procs, udfs etc on to the test database. But for promoting them to QA or production they should open a ticket to operational DBA team so that operationl DBA can execute them on to QA/production.

    Each application has its own application DBA but operational DBAs are responsible for supporting all the applications in the organization and provide oncall support for all the production databases in the organization

    Making decisions for DR, replication, licensing etc.. would also be in the hands of operational DBA team and their manager.

    Regarding JDBC and cli, operational DBAs provide the required JDBC drivers and the application DBAs are responsible for configuring their applications to use JDBC or so forth..
    Last edited by blazer789; 07-20-10 at 18:50.

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Thanks, everyone.

    blazer789, it's interesting that production DBAs also take care of test/QA environments. This was not the case at our company. Prod support people were responsible for implementing changes (not only database related changes) to production. Test env was partially handled by dev DBAs.

  8. #8
    Join Date
    Jun 2009
    Posts
    272
    Bella,

    I said that Application DBAs are given dbadm authority on TEST databases so they can totally handle test environment. Operational DBAs are only responsible for creating the test databases and performing sysadm duties like altering tablespaces, altering bufferpools etc.. which cannot be done by DBADM authority.

    QA and Production environment will be handled by operational dbas. The reason why we don't want to give QA environment to application team is because we wanted to keep the QA system similar to that of Production.

    The main difference between QA and Production environments in our organization is that the application team will have select insert update delete on the QA database but they would just have select on production.

  9. #9
    Join Date
    Dec 2009
    Posts
    43
    Ha! When I was in the development team I did the database development. Then when I joined the dba team I was told that they didn't have anyone in the development team to do the database development work and it should be moved to the dba team (guess who got that one?).

    When they gave me DB2 to look after, I had one training course, someone appeared as if by magic and said "You look after DB2 now" then ran off making Zoidberg like whooping noises. That was my handover.
    Last edited by hazy_dba; 08-12-10 at 12:25.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •