SQL Productivity and Management Tools

ADDPART*

A utility to automatically add new partitions and determines disk & first key values.

AUTOSIZE

Resizes Enscribe and SQL/MP files by calculating extent sizes from used space.

ENS2SQL

A conversion tool that extracts Enscribe data (defined in a DDL dictionary) into a SQL table.

OBEYFORM*

A SQL/MP Reverse Engineering Tool for DBAs, SEs, & Architects.

PI

 Partition Info, a tool to list, count, sort, and summarizes files and execute command against.

PTRA

 A Parallel Tandem Reload Analyzer utility, for counts, slack, block info and more.

REPART*

 A Parallel Load Utility to Re-Partition SQL/Enscribe tables.

SQL2ENS

A conversion tool that extracts data using any user-supplied SQL statement into Enscribe.

SQLRECOMP

Automatically recompiles invalidated SQL programs, may user options available.

UPCATSTAT

Update statistics for all tables within any SQL catalog.  (No more “Warning – No Stats”).