Test 711: U2 UniData V6.1 Administration

Section 1 - Installation/Upgrade (12%)

1. Determine type of installation
2. Ensure memory and disk requirements are met Set environment variables - O/S and UniData Perform installation or release upgrade Start - Stop - Pause UniData License UniData

Section 2 - Configuration (14%)

1. Set UNIX and UniData shared memory parameters
2. Set udtconfig parameters
3. Manage system and database memory
4. Analyze IPC facilities
5. Setup and use printers and devices
6. Configure language group (internationalization)
7. Manage UDTelnet/UDSerial services

Section 3 - Accounts (8%)

1. Define UniData accounts
2. Create and delete accounts
3. Set UDT.OPTIONS
4. Save and restore accounts

Section 4 - File maintenance (24%)

1. Use static hashed and dynamic hashed files
2. Analyze large dynamic files
3. Create and delete files
4. Use alternate indexing
5. Use UniData file corruption detection tools
6. Conduct file analysis and sizing
7. Minimize file corruption
8. Repair corrupted files
9. Administer recoverable files
10. Administer Triggers

Section 5 - Performance/Tuning (11%)

1. Monitor and remove user processes and users
2. Monitor UniBasic and resource locks
3. Manage cataloged programs
4. Link C routines to the runtime
5. Conduct database performance monitoring

Section 6 - Client access (8%)

1. Install middleware components
2. Configure middleware components
3. Use UCI Editor
4. Test Connectivity
5. Prepare files for SQL access
6. Use Visual Schema Generator
7. Manage SQL privileges

Section 7 - Security (8%)

1. Customize a VOC file to limit user access
2. Use pointers and remote items
3. Control user ECL access
4. Setup file access and user permissions

Section 8 - Troubleshooting (14%)

1. Investigate and resolve crashes and restart problems
2. Troubleshoot daemons and services
3. Diagnose response issues
4. Interpret error messages
5. Analyze log files
6. Analyze database processes