Administrating PM&A (T’A) – Technical
To enable participants to maintain the system and auxiliary modules.
This training is proposed to superusers responsible for technical maintenance.
Topics Include
- Understanding the architecture of the application
- Understanding the Unix and Sybase parts of Triple’A
- Triple’A user creation and configuration, including Triple’A profiles
- Triple’A server configuration
- Understanding all the security concepts of Triple’A
- Understanding the batch process, host comparison and user-defined fields
- Understanding the Triple’A technical parameters
- Registry content linked to the GUI
- Standard administration scripts
- Performance aspects
- Audit
- Actuate and Live!Report introduction
- Triple’A printer configuration
- Data Stage and Gateway introduction
- GUI localisation and GUI colour configuration
- Synthetic data
- TASC and WUI overview
Target Audience
Technical Superusers.
Prerequisites
Bronze Accreditation – RM & PM workstation
Or previous training : Introduction to PM&A (T’A)
Basic technical background (such as Unix and/or Sybase).
Other training would be helpful to broaden the understanding of the functional context, but is not essential to perform most system administration tasks.
Course Duration
2 days
Frequency of the Course
Every 3 months
Administrating Sybase (T'A) – Technical
This course enables the participants to do the Sybase administration tasks linked to Triple’A.
Topics Include
- Sybase architecture (dataserver, backup server)
- Understand what is an open server, a Triple’A server
- Sybase tools (Sybase Central, isql)
- How to start, stop and check the Sybase processes
- Determine Sybase version and Open client version
- Overview of the $SYBASE directory
- Understand the interfaces file, SYBASE.sh, the RUN files, the sql.ini, …
- Understand the Sybase variables (e.g.: DSQUERY, …)
- Sybase databases concept
- Data allocation including databases (and their options), devices (see the raw device, filesystem and RAM disk aspects), and segments
- Be able to analyze the free space
- Content of the different database
- Locking scheme concept (ROL, DOL, APL)
- Security concepts (login, users, role , group)
- Backup and restore (dump, load)
- Table content extration/importation (bcp)
- Database consistency check (dbcc commands)
- Process management
- Batch overview
- Performance aspect: update statistics, reorg, sp_recompile, cache configuration
- See how to check who is logged, how to kill a Sybase connection, how to determine who is generating locks, determine the query plan of a query which lasts to long
- Triple’A meta-dictionnary
- EBF installation
- And many exercises are included during the training
Target Audience
All the people who have to deal with the Triple’A Sybase database (Super users, technical users, DBA, system engineer)
Prerequisites
No pre-requisite required, but the “Introduction to PM&A (T’A) is highly recommended.
Course Duration
Stand alone duration: 2 days
If this course is concatenated with the SQL course for Triple’A (2 days), the two courses can be given in 4 days.
Inside PM&A (T’A) – Navigating with SQL Language
This course enables the participants to be able to launch different SQL commands. The course is based on a Triple’A database; therefore, the data model of Triple’A is used during the course and bring simultaneously a better knowledge of the different Triple’A tables.
Topics Include
- Database concept (table, datatype, keys, view, index, database)
- SQL basics: select, insert, select into, update, dalete
- Join and union uncluding inner and outer joins
- Summarizing, grouping and sorting
- Datatype conversion, and see different Sybase functions
- Table and view creation/deletion, modification
- Concept and creation of stored procedures
- Be able to find an object by using the table sysobjects
- Using subqueries
- Be able to create a file which contains the output of a SQL command
- Introduction into the performance aspect
- Use the Sybase help “Sybooks”
- Sybase query tools : isql (with the options) and SQL Advantage
- How to secure a SQL statement within a transaction
- Triple’A data model and meta-dictionnary
- And a lot of exercises are included during the training
- See how to check who is logged, how to kill a Sybase connection, how to determine who is generating locks, determine the query plan of a query which lasts to long
Target Audience
All the people who are doing SQL request on a Triple’A database.
Prerequisites
No pre-requisite required, but the “Introduction to Triple’A” is highly recommended.
Course Duration
2 days