How to Be a DBA with Visual DBA

1
How to Be a DBA with Visual DBA

• Or
• What to do without a Green Screen

Steve Rundle UKIUA 2004- Ditton Manor
2
Abstract

• Visual DBA is a GUI based tool provides a windows
  environment for IDMS database administration.
• This session will show how it is possible to do
  (some of the) DBA functions without touching a
  Terminal Emulator.
• This session will examine what benefits and
  problems amy be encountered by using the Visual
  DBA tool.
• Functions which will be discussed will include
• Adding and Modifying IDD elements/records
• Adding and Changing Schemas
• Modifying DMCLs and DBTABLEs
• Managing Security
• Administering Userids
• Monitoring an IDMS CV.
• And more...

3
Topics

• Introduction
• What does a DBA do?
• What is VDBA?
• Setting up VDBA
• What can it do? / what CANT it do?
• What about future VDBA?
• Questions?
• Demo

4
Introduction

• Who am I?
• Steve Rundle
• Why VDBA for BT?
• Many IDMS systems
• Smaller Support Teams
• MVS operations.
• DBAs
• Need an easy-to-use tool.
• VDBA was examined.

5
What does a DBA do?

• Development
• Schemas
• Database design
• ADS Modules
• General Admin
• Dictionary Admin
• Security Admin
• Operational Support for IDMS
• Monitoring IDMS
• Performance
• etc etc etc.

6
What is VDBA?

• Windows Graphical interface for IDMS
• SQL Inteface with IDMS
• Uses Server and SQL
• New!! From 15.0 Sp5/14.1 SP7 Not required.
• (See http//esupport.ca.com/ )
• Free with IDMS/DB

7
Setting Up VDBA

• CV
• SQL Option Server
• lite version
• CCI Line
• IDD entries SQL Tables Table procedures
• Windows PC Client
• ODBC
• CCI Line
• IDMS Server
• VDBA program

8
Topics

• Introduction
• What does a DBA do?
• What is VDBA?
• Setting up VDBA
• What can it do? / what CANT it do?
• What about future VDBA?
• Questions?
• Demo

9
What Can It DO?

• Multiple CVs
• IDD
• Records etc.
• Drag And Drop
• Schema Subschemas
• DMCLs DB Tables
• CV System
• Security
• Monitoring activity
• Online Admin Commands

10
Multiple CVs
11
IDD

• IDD Records
• Drag And Drop

12
Schema Subschemas
13
DMCLs DBTables (dict)
14
DMCLs DBTables (CV)
15
CV System
CV Pterm
Alter...
16
Security
17
Monitoring Activity
18
Monitoring Activity-2
19
What Can It DO?

• Multiple CVs
• IDD
• Records etc.
• Drag And Drop
• Schema Subschemas
• DMCLs DB Tables
• CV System
• Security
• Monitoring activity
• Online Admin Commands

20
Online Admin Commands

• DCMT
• DCUF
• OCF
• DMCL
• Sysgen
• Buffers
• Program/Storage Pools
• Shutdown

21
DCMT
22
DCUF
23
OCF
24
DMCL
Alter...
25
SYSGEN Dict
26
SYSGEN commands
27
Buffers
28
Program stg pools
29
Shutdown
30
What Cant it do?

• Batch stuff
• CV Startup Shutdown
• Reorg
• Unload/Reload
• Future?

31
Useful Stuff for DBAs

• Log off Users
• Increase Buffers
• Storage Pools
• Security
• Dictionay security and IDMS Security

32
Topics

• Introduction
• What does a DBA do?
• What is VDBA
• Setting up VDBA
• What can it do? / what CANT it do?
• What about future VDBA?
• Questions?
• Demos

33
Future for VDBA

• OLP ?
• Print Space ?
• Print Page ?
• Fix Page ?
• Reorg/Unload/Reload?
• TCP-IP enabled ?
• VDBA on a Web Page

• Easy Cancel User
• See Areas Offline
• IE5/WinXP look/feel
• VDBA User Profiles
• Dynamic Prog/Task
• Audit on ALL changes,

• If you want it then submit a suggestion

34
Topics

• Introduction
• What does a DBA do?
• What is VDBA
• Setting up VDBA
• What can it do? / what CANT it do?
• What about future VDBA?
• Questions?
• Demos

35
Questions

• ?

36
Demo

• Ill dial up and perform a demo.
• Any suggestions?

37
Topics

• Introduction
• What does a DBA do?
• What is VDBA
• Setting up VDBA
• What can it do? / what CANT it do?
• What about future VDBA?
• Questions?
• Demos

38
Session Evaluation Form
After completing your session evaluation form ...
... please place it in the box at the back of the
room.