Managing the migrated Zim/SQL environment using Zim Fuzion

Fuzion is a tool specially designed to simplify and accelerate the management of a client server environment formed by a Zim application layer connected to one or more SQL database servers.

It is a Zim DBA and developer oriented tool that makes managing data dictionaries and main functions of alternate third party Servers as simple as Zim. Tasks such as data dictionaries comparison and synchronization, tables import and export among servers and applications, answers to questions like which users are currently logged in the Server or which user is holding locks, are a few examples of what Fuzion can do for your developing team.

From your Zim application and using “Zim like” commands you can discover issues such as the top 10 SQL resource spenders or how your Zim command will be executed on the server to maximize index usage and even which indexed fields are never used.

Fuzion is composed of a series of services that can be invoked from the Zim command prompt, from a graphical interface or also from a Zim program. Each service has a unique name and an alias that you can customize as you prefer. Services are divided into 4 groups:

  1. Zim-Oracle group: groups together all services that involve Zim and Oracle definitions like tables or fields comparison, import and export table definitions.
  2. Oracle group: contains all series related to the Server maintenance itself like CPU and memory and IO usage, commands execution plan, etc.
  3. Connection group: services to create connections - connect and disconnect from different databases.
  4. General services group: redirect Fuzion output, set the services and help language and manage services.

Fuzion can be configured on the fly to display messages and help documentation both in English and Portuguese. The available Fuzion services and their names are:

Service Name Alias Name Syntax / Description
**** Group Zim/Oracle ****
$CompareFields $CompareFlds $CompareFields <TableName>
Compare Zim fields and Oracle columns for a choosen table.
$CompareTables $CompareTab $CompareTables [ALL | ZIM | ORACLE]] default is ALL
Compare existence of tables in Zim and Oracle
$ExportSQL $ZimExport $ExportSQL [dirname.]EntName [< Optional-param > = < value >]
Export Zim table definitions to Oracle schemas.
$OraFlds $OraFields $OraFlds < table-name >
List columns, indexes, triggers, etc. for an Oracle table
$OraImport $SQLImport $OraImport < table-name > [< zim-dir-name >]
Import a table definition from the Oracle database.
$OraTables $OraTabs $OraTables [< table-name >]
Lists one or more Oracle tables
$ZimFlds $ZimFields ZimFlds
[IDX|VIRT|REQD]
List fields of a Zim table (Entityset or Data Relationship)
$ZimOraFlds $ZimOraFields $ZimOrafields < table-Name >
List Zim fields and Oracle columns for a table, side by side
$ZimTables $Ents $ZimEnts < name >
List all defined Zim tables or the table named < Table-name >
$AllUsersSessions $AllSessions $Allusersessions
List all users sessions details
$CPUusage $cpu $CPUusage [< UserName >/< SID >] or $CPUusage ALIAS < alias >
List the CPU Usage for each user
$ExplainInit $ExplainINI $ExplainINIT
Create the Plan_Table table to use with EXPLAIN PLAN
$ExplainPlan $Explain $ExplainPlan [Editor | Screen | Window] [PrintZim][PrintSQL]
Shows the Oracle's Execution Plan for a Zim command.
$ExplainShow $ShowPlan $ExplainShow [Screen | Window | Editor]
Displays the last executed $ExplainPlan
$HitRatio $UserHitRatio $HITRATIO [ALL]
List relations between physical and logical data access.
$HoldingLocks $Locks $HoldingLocks
Show all users that are holding locks
$IndexStatistics $IndStats $IndexStatistics [ALL | < table >] (default is ALL
List statistics for a table or all tables
$IOUsage $IO $IOUsage [< Username >/< SID >/All]
Lists the sessions I/O usage
$MissingDefs $MissDefs $MissingDefs
Compare Zim and Oracle DD and list missing definitions
$MyConnections $MyConn $MyConnections
Show all current user's connections to Oracle
$NLSParameters $NLSParam $NLSParameters [< Param > [value] }
Lists or sets NLS Parameter for the current session
$OraConn $Connect $OraConn < Connection-name >
Connects the application to Oracle using a Connect
$Resources $resource $Resources [< UserName >/< SID >]
List Oracle Resources usage per user.
$UserSession $Sessions $UserSession
Return details of all current Sessions
**** Group General ****
$FuzionOutput $FuzionOut $FuszonOutput [SCREEN | EDITOR | WINDOW |< docname >] [APPEND]
Redirects the output to SCREEN, Editor or Window
$FuzionTools $Tools $FuzionTools [ LONG | L ]
List all Torch Fuzion tools, aliases and short desc
$SetLanguage $SetLang $SetLanguage P | E
Set the language of your choice (English/Portuguese)
**** Group Connect ****
$ConnectionMGR $ConMGR $ConnectionMGR or $ConnectionMGR ALIAS < alias-name >
Opens the Connections Center window. to Manage connections
$CreateConn $criacon $Createconn [< conn-Name >] or $Createconn ALIAS < alias >
Create a new Connection. name.
$Disconnect $discon $Diconnect or $Diconnect ALIAS < alias-name >
Disconnect from the current connection.