Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is the work of a DBA in IDMS database

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
View previous topic :: :: View next topic  
Author Message
sivasaras

New User


Joined: 29 Sep 2007
Posts: 90
Location: chenna/i-

PostPosted: Mon Apr 06, 2009 5:07 pm    Post subject: What is the work of a DBA in IDMS database
Reply with quote

Can anyone explain what is the work of a DBA in IDMS database?

Regards,
Siva
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Apr 06, 2009 8:27 pm    Post subject:
Reply with quote

Hello,

Basically the same as IMS or DB2 or Datacom or etc DBA.

The names of the tools and terminology are product specific, but the actual work is quite similar.
Back to top
View user's profile Send private message
sivasaras

New User


Joined: 29 Sep 2007
Posts: 90
Location: chenna/i-

PostPosted: Tue Apr 07, 2009 5:22 pm    Post subject: hi
Reply with quote

Thanks for the Reply

i am new into the role of a DBA administrator, so kindly tell me what are the main areas i should concentrate as a DBA.


Thanks & Regards,
siva
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Apr 07, 2009 8:54 pm    Post subject:
Reply with quote

Hello,

Suggest you talk with the senior dba(s) who support your system.

What you will actually do is quite site-specific. What you do will depend on what activities are currently going on and what parts of this activity will be your responsibility. Depending on whether there is new development, some major enhancement to an existing system, or routine maintenance going on, what you do will be determined. Again, site-specific.

Do you have experience with the tables and programs that you are now going to support? If not, becoming familiar with the structure and content of the tables would be good as well as the key processes (the ones most important to the users and/or the ones that use the most system resources).
Back to top
View user's profile Send private message
ovreddy

Active User


Joined: 06 Dec 2004
Posts: 211
Location: Keane Inc., Minneapolis USA.

PostPosted: Tue Apr 21, 2009 12:59 am    Post subject:
Reply with quote

Hi,

It is same as other DBA do. Our DBA will do the following things
1. Regular resizing of areas also called of Database Expansion
2. Resizing and rebuilding of indexes
3. Adding new journals
4. Defining new Schemas and subschemas
5. Monitoring backup and restore activities (Preparing batch jobs for the same)
6. DBA is responsible for recycle of IDMS. (Shutdown and startup)
7. DBA has to answer all Database related queries.

DBA has to do a lot more than this. These are basic activities every one do.

Thanks,
Reddy
Back to top
View user's profile Send private message
sivasaras

New User


Joined: 29 Sep 2007
Posts: 90
Location: chenna/i-

PostPosted: Tue Apr 21, 2009 8:58 am    Post subject: Hi Reddy,
Reply with quote

Thanks for the information.

I am new to this IDMS DBA.

My question is whether SYSTEM DBA is different from the IDMS DBA.

Thanks
siva
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Apr 21, 2009 9:06 am    Post subject:
Reply with quote

Hello,

What does the term "system dba" mean in your organization? It may have some special meaning in your organization, but it is not an industry "standard" term.

You organization may differentiate between those who install the product and upgrades/fixes from the vendor from those who support the application developers directly. One of the organizations i've supported has people in the "system programmer" group that does product installation and production database support while each major project has dbas that work with the logical and physical models and support the developers.

Some of the organizations i've supported do everything with one or 2 dbas that are responsible for everything used by "their" database environment.

Someone in your organization can best tell you how your environment is organized.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts IDMS/DC-COBOL program - SNAP error wh... rakeshsekar1987 IDMS/ADSO 5 Tue Sep 13, 2016 8:28 pm
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts ADS 3270 Batch simulator for IDMS rel... gpowell382 IDMS/ADSO 1 Thu May 05, 2016 8:02 pm
No new posts ALTER of an IDMS AREA with NEW/OLD pa... Awanti IDMS/ADSO 2 Mon Mar 14, 2016 10:01 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us