About Admin

This author has not yet filled in any details.
So far Admin has created 24 blog entries.

Server K-Indexes

Understanding the K tables and indexes concepts with our Windows/SQL Server and UNIX/Oracle products.

Planner Removal of Years – Data, DSL tables and Year ViewSet Items.

The removal of years that are displayed and retrieved using Stratum.Planner app requires clearing data from the DSL data tables and removing/deleting the physical DSL data tables.

Once data has been cleared for years from the DSL data tables and the physical DSL data tables are removed/deleted, the specific Year ViewSet Items can be deleted.

Important Note: […]

Server iSeries UL

Automation for Refreshing Dynamic User List
Important Note: This whitepaper is for iSeries installations only.

This utility provides the capability to refresh dynamic user lists in batch.  By including this utility in a nightly process, dynamic user lists can be refreshed after the database has been updated.

Restore the program REFRESHUL from the save file AIREFRESH to a library.
Include […]

Planner View and Template Calculations

View and Template calculations for Stratum.Planner

Planner on Citrix/Terminal Server

Instructions to install Stratum.Planner on a Citrix or Terminal server.

Test Environment for iSeries DB

CPYDBLIB is a Silvon command for iSeries that creates a new database library and allows new product feature testing.

Inplace and Reverse Transaction Change Sets

Using Inplace ChangeSets vs. Reverse Transaction ChangeSets.

Automating Change Sets

When a large number of changes need to be made, or the same type of change is routinely made, many companies automate the change set process. This helps insure that changes made to master file entries in the transaction-based application (i.e. customer master information) are reflected in DataTracker's historical data.

Server iSeries Batch

Automate batch jobs utilizing memory on iSeries.

Server iSeries Dedicated Subsystem for Memory

Create a dedicated subsystem and job queue for iSeries batch jobs to utilize memory when processing server jobs.