This document provides installation instructions for ICM11.0(1) ES10. It also contains a list of ICM issues resolved by this engineering special. Please review all sections in this document pertaining to installation before installing the product. Failure to install this engineering special as described may result in inconsistent ICM behavior.
This document contains these sections:
The Product Alert Tool
offers you the ability to set up one or more profiles
that will enable you to receive email notification of new Field Notices,
Product Alerts or End of Sale information for the products that you have selected.
The Product Alert Tool is available at
http://www.cisco.com/cgi-bin/Support/FieldNoticeTool/field-notice
This patch updates the Index Reorg stored procedure to allow it to handle special datatypes in an Enterprise Edition SQL Server. This was found and recorded with defect CSCuz85841. It will do no harm even if it is not required. It can be applied to a Standard Edition SQL Server as well, it is just not required.
This patch should be applied for an HDS, version 11.0(1) or higher, which is running with Enterprise Edition. It is wrapped into the FCS code that ships with 11.5(1). There is an equivalent patch for 11.0(2).
This patch is specific to ICM 11.0(1).
This patch should be used on any HDS that is using SQLServer Enterprise Edition.
This patch takes about 5 minutes to intall. It will ask for a server restart.
The package will replace the stored procedure under c:\icm\install (or whatever drive ICM has been installed on). Once the file has been replaced it will need to be compiled against the HDS. Instructions for that and verifying that it installed properly are shown during the install process. They are repeated here:
1. Determine the name of your HDS database. You can either view the name in SQL Server Management Studio or run the following command:
reg query "HKLM\SOFTWARE\Cisco Systems, Inc.\ICM\ActiveInstance"
The query returns the instance name, which is the root of the HDS database name; for example: [instance]_hds
2. Execute the following command: sqlcmd -d [Database Name] -i C:\icm\install\idxreorg.sql
3. Check properties for the dbo.defragidx stored procedure (SQL Server Management Studio->Databases->[Database Name]->Programmability->Stored Procedures). You can find this stored procedure near the end of the list. The Created Date for the procedure should reflect the current date and time.
To uninstall this patch, go to Control Panel. Select "Add or Remove Programs". Find the installed patch in the list and select "Remove".
Note: Patches have to be removed in the reverse order in which they were installed. For example, if you had installed patches 3, then 5, then 10 for a product, you will need to uninstall patches 10, 5 and 3 in that order to remove all patches for that product.
This section provides a list of significant ICM defects resolved by this engineering special. It contains these subsections:
Note: You can view more information on and track individual ICM defects using the Cisco Bug Toolkit located at: http://www.cisco.com/support/bugtools/Bug_root.html
This section lists caveats specifically resolved by ICM11.0(1) ES10.
| Identifier | Severity | Component | Headline |
|---|---|---|---|
| CSCuz85841 | 2 | db.HDS | Index reorg with Enterprise Edition will fail on some tables |
Caveats are ordered by severity then defect number.
Defect Number: CSCuz85841
Component: db.HDS
Severity: 2
Headline: Index reorg with Enterprise Edition will fail on some tables
The following sections provide sources for obtaining documentation from Cisco Systems.
You can access the most current Cisco documentation on the World Wide Web at the following sites:
Cisco documentation and additional literature are available in a CD-ROM package, which ships with your product. The Documentation CD-ROM is updated monthly and may be more current than printed documentation. The CD-ROM package is available as a single unit or as an annual subscription.
Cisco documentation is available in the following ways:
If you are reading Cisco product documentation on the World Wide Web, you can submit technical comments electronically. Click Feedback in the toolbar and select Documentation. After you complete the form, click Submit to send it to Cisco.
You can e-mail your comments to bug-doc@cisco.com.
To submit your comments by mail, use the response card behind the front cover of your document, or write to the following address:
Attn Document Resource Connection
Cisco Systems, Inc.
170 West Tasman Drive
San Jose, CA 95134-9883
We appreciate your comments.
Cisco provides Cisco.com as a starting point for all technical assistance. Customers and partners can obtain documentation, troubleshooting tips, and sample configurations from online tools. For Cisco.com registered users, additional troubleshooting tools are available from the TAC website.
Cisco.com is the foundation of a suite of interactive, networked services that provides immediate, open access to Cisco information and resources at anytime, from anywhere in the world. This highly integrated Internet application is a powerful, easy-to-use tool for doing business with Cisco.
Cisco.com provides a broad range of features and services to help customers and partners streamline business processes and improve productivity. Through Cisco.com, you can find information about Cisco and our networking solutions, services, and programs. In addition, you can resolve technical issues with online technical support, download and test software packages, and order Cisco learning materials and merchandise. Valuable online skill assessment, training, and certification programs are also available.
Customers and partners can self-register on Cisco.com to obtain additional personalized information and services. Registered users can order products, check on the status of an order, access technical support, and view benefits specific to their relationships with Cisco.
To access Cisco.com, go to: http://www.cisco.com
The Cisco TAC website is available to all customers who need technical assistance with a Cisco product or technology that is under warranty or covered by a maintenance contract.
If you have a priority level 3 (P3) or priority level 4 (P4) problem, contact TAC by going to the TAC website: http://www.cisco.com/tac
P3 and P4 level problems are defined as follows:
In each of the above cases, use the Cisco TAC website to quickly find answers to your questions.
To register for Cisco.com, go to the following website: http://www.cisco.com/register/
If you cannot resolve your technical issue by using the TAC online resources, Cisco.com registered users can open a case online by using the TAC Case Open tool at the following website: http://www.cisco.com/tac/caseopen
If you have a priority level 1(P1) or priority level 2 (P2) problem, contact TAC by telephone and immediately open a case. To obtain a directory of toll-free numbers for your country, go to the following website: http://www.cisco.com/warp/public/687/Directory/DirTAC.shtml
P1 and P2 level problems are defined as follows: