Table Of Contents
Configuration Extraction Tool
Fields Addressed by CET
Using the CET
Other CET Commands
AIX Platform Support
Troubleshooting CET
Remote CET Extracts
Troubleshooting
Configuration Extraction Tool
This chapter describes how to use the Configuration Extraction Tool (CET). The CET extracts data from the Informix database used by the Cisco Wan Manager (CWM), formerly called StrataView Plus.(SV+). The CET then formats the data into a standard .cnf file that can be read by the NMT. The CET works with CWM Releases 9.2 through 15, and with SV+ Release 7.0 or greater. CET is included in the UNIX installation of NMT. For instructions on installing the CET, see the chapter "Installing WAN Modeling Tools."
This Chapter contains the following sections:
•
Fields Addressed by CET
•Using the CET
•Other CET Commands
•Troubleshooting CET
•Remote CET Extracts
Fields Addressed by CET
A configuration file generated by the CET consists of data extracted from your network. The source is the CWM Informix database. Where that data is not available, NMT default values are used. See "Configuration Tables and Fields," for descriptions of the fields that are extracted from the CWM data, and their source fields and their limitations.
CET provides the added functionality of translating all coded value fields in INFORMIX into easy to use strings. For some fields, CET will check 2nd sources for the data if there are problems with the CWM collection process. For older versions of CWM, specifically 9.1 or earlier, CET will heuristically fill in some fields
Using the CET
To extract data from CWM and generate an NMT-compatible .cnf file, perform the following steps:
Step 1 For the best data consistency, make sure the network is not running any administration activities that add or delete network elements. Also, make sure you are in the correct working directory, and that the CET has been installed there.
Note If you run CWM on the IBM AIX platform (which is not supported by NMT), you can still run the command svp2cet. You then need to tar the network directory, move it to your NMT platform, and untar it before running the cet2nmt command.
Step 2 The svp2cet command extracts flat files from the SQL database and writes them in the sub-directory ntwk_name. If the command fails or generates warning messages, view the file ntwk-name/svp2cet.con for a log of SQL extraction.
To extract the configuration from CWM, enter the following command:
svp2cet <netw_name> {options]
netw_name is the name of the directory that the command creates. The directory contains data files that are used as inputs for the command shown in the next step, which builds a.cnf file. You will use this directory name again in the next step.
swt_rev is the switch software revision you are using. You may need to use this option only if the CWM release is more recent than the switch software release.
Note It may take a long time for the extraction process to run. There is no on-screen indication that the process is running. A message appears announcing when the process is complete or another message appears if the process fails. If the process fails, delete the ntwk_name directory before running the command again.
Step 3 Enter the following command to format the above extracted data into a .cnf file named ntwk_name.cnf, which you can read into NMT. If the command fails or generates warning messages, view the file ntwk-name/cet2nmt.con for a summary of the data analysis problems:
cet2nmt <netw_name> {<nmt-ver>}
netw_name is the name of the directory you created.
cet2nmt has an option to extract a single domain or several domains from the CWM DB. If your CWM is monitoring multiple AutoRoute networks, or multiple PNNI peer groups, you may extract a single or multiple domains using the -network option.The syntax is as follows:
cet2nmt <myplan> -network <domain_name>
Multiple domain names can also be specified, as shown in the following example:
cet2nmt <myplan> -network <domain_name1> <domain_name2>
Step 4 This step is optional.
If manual corrections are required on the output CNF file, you can make them once, and then automatically make them again with the 'adj2nmt' command. The command only updates fields that are missing from CWM or are not that reliable. The site names, and slot port information is used to match links and connections. Messages are generated for every change.
adj2nmt <in-file> <reference-file> <out-file> {[options]}
in-file is the most recent extraction file.
reference-file is the extraction with the manual changes applied
out-file in the input file with the same parameters changed on the output file.
Options:
•-add—Add links and connections that are in the reference file but missing from the input file.
•-diffrep—Write no output file, but generate a report about the differences of the two files.
Note The field update functionality and the topology compare functionality can now be called directly from the NMT menu under FILES/READ 2ND CNF.
This process is illustrated in Figure 9-1.
Figure 9-1
CET Schematic Overview
Other CET Commands
There are several other CET commands that may help you more effectively use the software:
•svp_dmp. Use this command to if the CET generates a defective .cnf file. This command should be run immediately after you run the svp2cet command. This command dumps the data from CWM tables into a series of .dmp files. These files can be analyzed by your Cisco customer support representative. Enter this command as in the following example:
nwt_name is the name of the network.
•svp_rev—Use this command to find out the CWM revision level.
•swt_rev—Use this command to find out the software revision level of your switches.
•adj2nmt—Use this command to recreate manual changes on previous extractions to current extractions.
•sniffcnf ntwk_name—Use this command to obtain an on-screen summary of the network topology. This is useful for a high-level check that the data extraction was successful.
The following CET installation commands are not required to run unless NMT was installed as stand-alone:
•cetlink— Use this command to copy the necessary CET files to your project directory. You can invoke it by running the command $CETHOME/cetlink
•cetrel—Use this command to remove the CET software from your project directory.
To obtain help about any of the CET commands, enter the command followed by -h, for example, cet2nmt -h.
AIX Platform Support
If you have CWM installed on an AIX platform, run the svp2cet command on that platform and run the rest of the process on a support UNIX platform. Install the NMT on both the CWM AIX platform and a standard platform. After running the svp2cet command, copy the entire subdirectory with the plan name you entered to your working directory on the standard platform. Then, run the cet2nmt command to complete the extraction process.
To move the entire sub directory, use the UNIX tar command, then transfer the tar command in binary mode and untar it on the standard platform.
Troubleshooting CET
Occasionally, CET will execute successfully, but the resulting extract will be incomplete. If CET fails during the svp2cet command, look at the earliest error in the svp2cet.con file. The table below lists some common problems, and what to do about them.
Symptom
|
Links are missing
|
Probable Causes
|
Incomplete data in SV+ database.
|
Solution
|
View the file named maybe_links.sv. This file contains possible links based on incomplete data. If the missing links are in this file, add them to the links.svp file, and rerun cet2nmt.
|
Symptom
|
Connections are missing.
|
Probable Causes
|
Incomplete data in SV+ database.
|
Solution
|
CWM 9.2 or higher: View the files that begin with the word extra. These contain connection segments that are in the data base, but which were not collected because they were not part of an end-to-end connection.
SV+ 7.0 - SV+ 9.1: View the files maybe.voice.svp, maybe_data.svp, maybe_frame.svp, and maybe_atm.svp.
If you find the connections, try rerunning svp2cet and cet2nmt.
If this doesn't succeed, contact WAN Manager support.
|
Symptom
|
Informix Error 862 (cannot open file for run)
|
Probable Causes
|
cetlink has not been run.
User is executing CET from a subdirectory
CET installation did not execute properly.
|
Solution
|
Make sure this directory contains cetbin:
ls-1 cetbin
if cetbin is not there, run cetlink
See if all required subdirectories and programs are in cetbin. If they are not there, you must reinstall CET.
|
Symptom
|
Informix Error 529 (Cannot attach to shared memory)
Informix Error 123 (ISAM error: No shared memory)
|
Probable Causes
|
Informix DB is not on line.
|
Solution
|
1 Become the Superuser INFORMIX
2 Type cd
3 Type tbmonitor, or bin/tbmonitor
4 In tbmonitor, select mode. This will confirm that the database is off-line.
5 Select start-up.
The database is brought from off-line to quiescent.
6 Select on-line.
This brings the database on-line
7 Select exit to exit mode.
8 Select exit to exit tb monitor
9 Exit informix
|
Symptom
|
Informix Error 217 (Column [name of column] not found in any table in the query)
|
Probable Causes
|
CWM release and the Informix Database are incompatible. In other words, a new sv+ has been installed, but is not in use
|
Solution
|
Use the swt_rev option on the svp2cet command.
|
Symptom
|
Informix Error 564 (Cannot sort rows)
and/or
Informix Error 407 (Error number 0 received from sql_exec process)
The above error(s) are also combined with a unix error: /:write failed, file system is full
|
Probable Causes
|
There is not enough empty space in the /tmp partition, where informix does its sorting work
|
Solution
|
If there are files called textnnn.0, then space can be recovered by closing the shell tools.
If this still doesn't work, space can be cleared by copying info and files to other partitions (then erasing them from /tmp)
|
Symptom
|
Informix Error 229 (Cannot open or create a temporary file)
and/or
Informix Error 162 (ISAM error: BLOB space does not exist)
|
Probable Causes
|
The Informix database is full or almost full, or the temporary space directory is not writable or full
|
Solution
|
Check that the directory defined by the DBTEMP environment variable is writable by this account. If DBTEMP is not defined, check the /tmp directory. The problem could also be that there is no more free disk space in the temporary directory.
If you have error 162, have TAC increase the user's Informix database size.
|
Symptom
|
REXX Error 48: Failure in System Service
|
Probable Causes
|
Not enough memory available. This usually refers to swap-space. (To see how much swap space is available, use the pstat -s or swap -s command. To see how much memory is available, use the dmesg | grep avail mem command
|
Solution
|
Close all other applications that use a lot of memory, such as Sun's file manager or Netscape.
|
Symptom
|
REXX Error 41: Bad Arithmetic Conversion
|
Probable Causes
|
The input data contained a blank rather than a digit.
|
Solution
|
No workaround.
Contact Network Modeling for help.
|
Symptom
|
The following error message is displayed:
Console file from the svp2cet command shows some queries and then SQL error 802
|
Probable Causes
|
The CWM is a newer version than NMT, and has tables or fields that NMT does not recognize.
|
Solution
|
Upgrade NMT to a later version that supports that version of CWM.
|
Symptom
|
The cet2nmt command displays the following error:
REXX: Service not available
|
Probable Causes
|
The command ran out of memory.
|
Solution
|
Reconfigure your system to use more swap space on disk.
|
Symptom
|
The %UTIL values extracted are bad.
|
Probable Causes
|
You are using CWM 9.2.09 and do not have patch 10 applied.
|
Solution
|
Apply patch 10 to CWM.
|
Symptom
|
The CET installation says that CWM is not installed, and you know that it is installed.
|
Probable Causes
|
The NMT version is too old for the CWM version, or the CWM is installed in a non standard way with a different DB name.
|
Solution
|
Upgrade NMT to a later version that supports that version of CWM.
|
Remote CET Extracts
If you wish to obtain a CET extract from a CWM or SV+ Informix database located on another workstation, you may not need to install NMT or CET on the remote platform. You may be able to issue the svp2cet command on your workstation and return the data from the remote platform to your workstation.
A remote CET extract is possible only in the following circumstance:
•You must have NMT Release 9.2.0.7, or higher.
•You must know the hostname of the remote host. You may need to know the IP address of the remote host.
•Your local host workstation must be able to access the remote host. That is, you must be able to successfully ping the remote host, either by hostname or by IP address, from your local host.
•Informix 7.2, or higher, must be installed on both your local host and the remote host. (If CWM or SV+, release 9.2 or higher, is installed on either host, you have met the requirement for that host.
•You must know the password to the svplus user ID at the remote host.
Note You cannot obtain a remote CET extract from a PC.
To configure the workstations for remote data extraction, follow these steps:
Step 1 Set the environment variable INFORMIXSERVER to the hostname of the remote host. That is, issue the following Unix command: setenv INFORMIXSERVER <remotehostname>
Step 2 Setup your local host with an Informix sqlhosts entry for the remote host.
a. Edit your /usr/users/informix72/etc/sqlhosts file.
b. Add a new entry of the following form (filling in the blanks): <remotehostname> ontlitcp <remotehostaddr> informix_istar
Note <remotehostaddr> is the IP address of the remote host; but, if you can ping the remote host by name, you can alternatively use the hostname of the remote host. Whichever you choose, use the same remotehostaddr in the two steps below.
Step 3 Setup your local host for "friendly" ftp access to the remote host's svplus userid.
a. Edit (or create) the .netrc file in your home directory.
b. Add a new entry of the following form (filling in the blanks): machine <remotehostaddr> login svplus password <password>
Note <password> is the password to the svplus account at the remote host. Therefore, your .netrc file should not allow others to read it. You can use the Unix command, chmod 600 ~/.netrc
Step 4 Setup the svplus userid on the remote host to allow remote shell access from your local host:
a. Remotely log on to the remote host as user svplus:
rlogin <remotehostaddr> -l svplus
b. Edit (or create) the .rhosts file in the svplus home directory.
c. Add a new entry of the following form:
<localhostname> <yourlocaluserID>
Note <localhostname> must be the official name of your host, not one of its nicknames. If you don't know it, execute the command, "who am i", after you have logged on to the remote host. Your official host name will appear within parentheses ().
To check whether your setup is correct, run the svp-rev and swt-rev commands. If both commands work correctly, your setup is correct.
Troubleshooting
Symptom
|
A command returns Informix error 23101:
Unable to load locale categories.
|
Probable Causes
|
The INFORMIXDIR environment variable is not set correctly
|
Solution
|
Either issue the command, unsetenv INFORMIXDIR, or the command, setenv INFORMIXDIR /usr/users/informix.
|
Symptom
|
A command returns Informix error 930:
Cannot connect to database server <remotehostname>
|
Probable Causes
|
Either Informix is not installed on the remote host, or the INFORMIXSERVER environment variable has been set incorrectly.
|
Solution
|
If Informix is installed, perform Step 1 of the Setup Procedure.
|
Symptom
|
A command returns Informix error 25596:
The INFORMIXSERVER value is not listed in the sqlhosts file or
the Registry.
|
Probable Causes
|
Informix sqlhosts file has not been updated.
|
Solution
|
Perform Step 2 in the Setup Procedure.
|
Symptom
|
A command returns Informix error 951:
Incorrect password or user <yourlocaluserID> is not known on the database server.
|
Probable Causes
|
The local host doesn't have "friendly" access to the remote host.
|
Solution
|
Perform Step 2 of the Setup Procedure, making sure that the <remotehostaddr> used is the same as that used in the sqlhosts file of Step 3 the setup procedure.
|
Symptom
|
A command returns the message:
Cisco Wan Manager (StrataView Plus) on host <hostname> is either
not installed or not accessible
|
Probable Causes
|
The remote host does not allow remote shell access.
|
Solution
|
Perform Step 4 the setup procedure.
|
Symptom
|
Command returns Informix error 908
|
Probable Causes
|
The remote CWM site is not up and running.
|
Solution
|
Verify the remote CWM site is running and can be pinged from your site.
|
