Implementation Overview › Required Implementation Skills

Required Implementation Skills

ReportCenter uses technologies external to CA NetMaster, such as Java and SQL Data Warehousing.

ReportCenter implementation can involve installation and setup of multiple program products from different vendors.

Successful ReportCenter implementation requires various skills and is a team effort. ReportCenter is unlike traditional CA NetMaster in that it requires technical expertise in many areas that CA NetMaster does not otherwise use.

Do not attempt to implement ReportCenter until you have arranged access to people with the following skills:

• z/OS UNIX System Services and the Hierarchical File System (HFS)-to set up a functional HFS and UNIX environment
• Communications Server (TCP/IP) or equivalent-to configure connectivity between CA NetMaster regions and the ReportCenter Java task
• Security Server (for example, CA ACF2 for z/OS, CA Top Secret for z/OS, or RACF), or the security product you use-to authenticate the ReportCenter Java task to USS, and authorize access to resources
• SMP/E and JCL-to install the ReportCenter feature
• Java for z/OS
• CA NetMaster-to set up regions, collect report data, and administer reports
• DB2 and JDBC-to define, authorize, tune the ReportCenter database, and implement the DB2 JDBC component
• Resource recovery services (RRS)-to implement resource recovery services as required by DB2
• Optionally, CA Datacom/AD and CA Common Services for z/OS

Planning for DB2 DBAs

ReportCenter is a DB2 application with the following characteristics:

• Database access is through JDBC.
• Typically, it uses only a single, persistent JDBC connection.
• A star schema data warehouse with large central fact tables is used.
• Queries involve sorting and joining, and need supporting DB2 resources such as sort work tables.
• All queries are dynamic SQL.
• 'uncommitted read' transaction isolation level is used.
• A combination of transaction-like and batch-like accesses are used.
• New data is added to the database continuously—typically around 100,000 rows per day. Periodically, old data is deleted, keeping the database size roughly constant.

To implement ReportCenter, perform the following DB2-related tasks:

• Define the ReportCenter DB2 database and its authority grants.
• Implement DB2 JDBC access to this database.

More information:

DB2 Administration

Planning for Security Administrators

To implement ReportCenter, you must grant security rights to a ReportCenter user ID in the following areas:

• DB2 SYSGRANT access to ReportCenter database and tables
• DB2 SYSGRANT access to JDBC plan
• Security access to RRS
• Security access to USS/OMVS
• Security access to started tasks
• USS access to HFS files

The implementation task descriptions contain additional details.