1 / 99

DMSII Administration for non DBA

DMSII Administration for non DBA. Presenters: Kung Lin, Don Hart, Subramaniam Ramamurthi (Ram) MCP 3035 May 24, 2011. Agenda. Database Operations Center (DOC) Installation DOC Security Consideration DOC Usage Preference & Overview Operation Event

marlis
Download Presentation

DMSII Administration for non DBA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DMSII Administration for non DBA Presenters: Kung Lin, Don Hart, Subramaniam Ramamurthi (Ram) MCP 3035May 24, 2011

  2. Agenda • Database Operations Center (DOC) • Installation • DOC Security Consideration • DOC Usage • Preference & Overview • Operation • Event • Database Modeling and Life Cycle maintenance • Feedback © 2011 Unisys Corporation. All rights reserved.

  3. Database Operations Center (DOC)Installation & Configuration

  4. Installation Overview 1. Run Setup 2. Configure Client Access Service (Named Pipes) 3. ACCESSCODE configuration © 2011 Unisys Corporation. All rights reserved.

  5. Modifying the Configuration File • To modify the Database Operations Center port file • definitions in the Client Access Services configuration, perform the following steps: • CAUTION: • | • Do not change the port name or record size attributes • Do not add any security attributes to the DBC_DUPLEX port file. © 2011 Unisys Corporation. All rights reserved.

  6. Modifying the Configuration File © 2011 Unisys Corporation. All rights reserved.

  7. Modifying the Configuration File © 2011 Unisys Corporation. All rights reserved.

  8. Modifying the Configuration File © 2011 Unisys Corporation. All rights reserved.

  9. Modifying the Configuration File © 2011 Unisys Corporation. All rights reserved.

  10. Modifying the Configuration File © 2011 Unisys Corporation. All rights reserved.

  11. Modifying the Configuration File © 2011 Unisys Corporation. All rights reserved.

  12. Modifying the Configuration File © 2011 Unisys Corporation. All rights reserved.

  13. Modifying the Configuration File © 2011 Unisys Corporation. All rights reserved.

  14. ACCESSCODE Configuration © 2011 Unisys Corporation. All rights reserved.

  15. ACCESSCODE Configuration © 2011 Unisys Corporation. All rights reserved.

  16. ACCESSCODE Configuration © 2011 Unisys Corporation. All rights reserved.

  17. ACCESSCODE Configuration © 2011 Unisys Corporation. All rights reserved.

  18. ACCESSCODE Configuration © 2011 Unisys Corporation. All rights reserved.

  19. ACCESSCODE Configuration © 2011 Unisys Corporation. All rights reserved.

  20. ACCESSCODE Configuration © 2011 Unisys Corporation. All rights reserved.

  21. ACCESSCODE Configuration © 2011 Unisys Corporation. All rights reserved.

  22. ACCESSCODE Configuration © 2011 Unisys Corporation. All rights reserved.

  23. DOC Security Consideration

  24. Security Consideration • Controlled Mode • DBA user code • User code with privilege attribute © 2011 Unisys Corporation. All rights reserved.

  25. Security Consideration - RBAC • Assisted Mode • DOC Role Based Access Control • New DASDL Syntax • Database Level Security Control • Pre-defined database operations © 2011 Unisys Corporation. All rights reserved.

  26. Security Consideration - RBAC • DASDL Syntax • CONTROL FILE (USERCODE = KUNG, DOCADMIN = KUNG); © 2011 Unisys Corporation. All rights reserved.

  27. Security Consideration – RBAC Before assigning any user code to a role only DOCADMIN can operate on the database. © 2011 Unisys Corporation. All rights reserved.

  28. Security Consideration – RBAC © 2011 Unisys Corporation. All rights reserved.

  29. Create Role Up to 17 Characters © 2011 Unisys Corporation. All rights reserved.

  30. Assign Permission • Analysis • Backup • Configuration • Dasdl Generator • QDC • Reorg • Recovery • RDBADMIN • RDBMONITOR © 2011 Unisys Corporation. All rights reserved.

  31. Assign User Code • Valid user code defined in the user data file © 2011 Unisys Corporation. All rights reserved.

  32. Security Consideration – RBAC • Pull down menu functions are available © 2011 Unisys Corporation. All rights reserved.

  33. Security Consideration – RBAC • Pull down menu functions are NOT available © 2011 Unisys Corporation. All rights reserved.

  34. DOC Overview

  35. Overview - Tools © 2011 Unisys Corporation. All rights reserved.

  36. Overview - Options Show Generated Commands © 2011 Unisys Corporation. All rights reserved.

  37. Preferences © 2011 Unisys Corporation. All rights reserved.

  38. Preferences – Job Monitor © 2011 Unisys Corporation. All rights reserved.

  39. Preferences Must be specified if your database control file location is not the same as user data file disk specification © 2011 Unisys Corporation. All rights reserved.

  40. Preferences – Email Attributes Allow users to send emails when a task completed © 2011 Unisys Corporation. All rights reserved.

  41. Menugraph DOCADMIN= SUBRA © 2011 Unisys Corporation. All rights reserved.

  42. Menugraph Logged as TRANM (privileged) DOCADMIN= SUBRA ROLE= REORGROLE © 2011 Unisys Corporation. All rights reserved.

  43. DOC UsageOperationEvent

  44. Database Operation – Home Screen © 2011 Unisys Corporation. All rights reserved.

  45. Database Operation © 2011 Unisys Corporation. All rights reserved.

  46. Database Operation © 2011 Unisys Corporation. All rights reserved.

  47. Database Operation © 2011 Unisys Corporation. All rights reserved.

  48. Database Operation © 2011 Unisys Corporation. All rights reserved.

  49. Database Operation © 2011 Unisys Corporation. All rights reserved.

  50. Database Operation © 2011 Unisys Corporation. All rights reserved.

More Related