asnanalyze: Operating the Analyzer
Use the asnanalyze command to generate reports about the state of the replication control tables. This command analyzes replication control tables that reside on any operating system, including IBM® i, however, you must invoke the command from Linux®, UNIX, or Windows.
CONNECT TO database_name;
CREATE BUFFERPOOL BUF8K SIZE 100 PAGESIZE 8K;
FORCE APPLICATIONS ALL;
TERMINATE;
CONNECT TO database_name;
CREATE SYSTEM TEMPORARY TABLESPACE TEMPSPACE2 PAGESIZE 8K MANAGED BY SYSTEM
USING ('C:\TEMPSPACE2') BUFFERPOOL BUF8K;
You must type a space between the asnanalyze command and the first parameter to invoke the command. If you issue the command without any parameters, you receive command help on the screen.
Syntax
Parameters
Table 1 defines the invocation parameters.
Parameter | Definition |
---|---|
-db db_alias | Specifies the Capture control server, target
server, and Apply control server. You must provide at least one database alias. If there is more than one database alias, use blank spaces to separate the values. |
-la level_of_analysis | Specifies the level of analysis to be reported:
|
-tl n | Specifies the date range (0 to 30 days) of entries to be retrieved from the IBMSNAP_APPLYTRAIL table. The default is 3 days. |
-at n | Specifies the date range (0 to 30 days) of entries to be retrieved from the Apply trace IBMSNAP_APPLYTRACE table. The default is 3 days. |
-ct n | Specifies the date range (0 to 30 days) of entries to be retrieved from the IBMSNAP_CAPTRACE table. The default is 3 days. |
-cm n | Specifies the date range (0 to 30 days) of entries to be retrieved from the IBMSNAP_CAPMON table. The default is 3 days. |
-sg n | Specifies the date range (0 to 30 days) of entries to be retrieved from the IBMSNAP_SIGNAL table. The default is 3 days. |
-aq apply_qualifier | Specifies the Apply qualifier that identifies
the specific subscription sets to be analyzed. You can specify more than one Apply qualifier. If there is more than one Apply qualifier, use blank spaces to separate the values. If no Apply qualifier is specified, all subscription sets for the specified database aliases are analyzed. |
-cs capture_schema | Specifies the name of the Capture schema that
you want to analyze. If you use this parameter, you can specify only one Capture schema. |
-od output_directory | Specifies the directory in which you want to store the Analyzer report. The default is the current directory. |
-fn output_filename | Specifies the name of the file that will contain
the Analyzer report output. Use the file naming conventions of the operating system that you are using to run the Analyzer. If the file name already exists, the file is overwritten. The default file name is asnanalyze.htm. |
-pw password_filepath | Specifies the name and path of the password file. If you do not specify this parameter, the Analyzer checks the current directory for the asnpwd.aut file. |
Examples for asnanalyze
The following examples illustrate how to use the asnanalyze command.
Example 1
To analyze the replication control tables on a database called proddb1:
asnanalyze -db proddb1
Example 2
To obtain a detailed level of analysis about the replication control tables on the proddb1 and proddb2 databases:
asnanalyze -db proddb1 proddb2 -la detailed
Example 3
To analyze the last two days of information from the IBMSNAP_APPLYTRAIL, IBMSNAP_APPLYTRACE, IBMSNAP_CAPTRACE, IBMSNAP_CAPMON, and IBMSNAP_SIGNAL tables on the proddb1 and proddb2 databases:
asnanalyze -db proddb1 proddb2 -tl 2 -at 2 -ct 2 -cm 2 -sg 2
Example 4
To obtain a simple level of analysis about the last two days of information from the IBMSNAP_APPLYTRAIL, IBMSNAP_APPLYTRACE, IBMSNAP_CAPTRACE, IBMSNAP_CAPMON, and IBMSNAP_SIGNAL tables on the proddb1 and proddb2 databases for only the qual1 and qual2 Apply qualifiers:
asnanalyze -db proddb1 proddb2 -la simple -tl 2 -at 2 -ct 2 -cm 2 -sg 2
-aq qual1 qual2 -od c:\mydir -fn anzout -pw c:\SQLLIB
This command example writes the analyzer output to a file named anzout under the c:\mydir directory and uses the password information from the c:\SQLLIB directory.
Example 5
To analyze a specific Capture schema:
asnanalyze -db proddb1 proddb2 -cs BSN
Example 6
To display command help:
asnanalyze