HP Service Manager: Database Administration
Documentation Home
HP Service Manager Documentation
Database Administration
UTF-8 (Unicode) support
MS SQL Server collation support
Attachments
Supported RDBMS
Backups
System Definition
System Definition utility
Access the System Definition utility
Table tab
Table definition
Table management
Editing System Definition nodes
Access field help from the System Navigator
Count records using Database Manager
Forms, triggers, and links
Update a form
Triggers
Create a Trigger record
Edit a trigger
Modify an existing link
Data persistence
Database dictionary records
Database dictionary records
Making database dictionary changes
Database dictionary data types
Changing data types
SQL data type for localizable fields
Change data types: character to number
List: Database dictionary data types
Arrays
Arrayed structures
Structures
Fields within structures
Organization of arrays of structure in the Database Dictionary
Example: Arrayed structure
Create the unique and attribute subtables
Name the unique and attribute files
View the unique and attribute subtables
Alias fields
Access the Database Dictionary utility
Enable DDL logging of database dictionary changes
Open a Database Dictionary
Copying a Database Dictionary
Copy a Database Dictionary and data records
Copy a Database Dictionary only
Methods for adding database dictionary records
Field name requirements
Create an active database dictionary record
Add a structure to the Database Dictionary
Add an alias field
Add an array
Add fields to a structure
Create a database dictionary record by importing RDBMS columns
Designate unique fields in the array of structures
Create an inactive database dictionary record
Activate a database dictionary record
Methods for deleting database dictionary records
Delete a database dictionary record
Remove a field from an existing database dictionary record
Methods for updating database dictionary records
Automatic update of database dictionary records
Automatic update of RDBMS data when database dictionary records change
Activate a database dictionary record
Add a field to an existing database dictionary record
Import RDBMS columns into an existing database dictionary record
Modify field types character (scalar) to array
Modify field types: single to concatenated
Regen a Database Dictionary
Search for a field in a Database Dictionary
Update an existing database dictionary record
Update the data type of a database dictionary field
Renaming a Database Dictionary
Rename a Database Dictionary
Resetting a database table
Resetting the database and all records
Reset a database table from Database Manager
Schedule a reset
Keys and indexes in HP Service Manager
List: Key type definitions
List: Key type attributes
Tuning: Designing keys for queries
Tuning: Key selection algorithms
Example: Key selection
Adding a Key
Add a key as the first key
Add keys to the bottom of a key list
Insert a key between other keys
Deleting a Key
Delete a key
Modifying a Key
Modify keys: Nulls and Duplicates to Unique
SQL cache
Regenerating database keys
Regenerate database keys
Schedule a regeneration
Data maps
Alternatives to data maps
Types of data maps
Add a data map record
Create data maps to related records
Delete a data map record
Update a data map record
View a data map record
Exporting records
Export descriptor records
List: Unload error messages
Unload files
Add an export descriptor record
Configure forms to prompt for a language when exporting to Excel
Delete an export descriptor record
Export a record list to a text file
Export a record list to an Excel file
Export a record list using an export description record
Export an individual record using an export descriptor record
Export selected records from a table using an export descriptor record
Schedule the exporting of records using an export descriptor record
Schedule the unloading of records
Unload a database dictionary only
Unload a record list
Unload an individual record
Unload records from multiple files
Unload selected records from a file
Update an export descriptor record
Importing records
Import descriptor records
List: load error messages and notifications
Unload files
Add an import descriptor record
Delete an import descriptor record
Import a character-delimited text file
Import a fixed-width text file
Import an external text file
Load an unload file
Schedule the importing of records using an import descriptor record
Schedule the loading of an unload file
Test the importing of records
Update an import descriptor record
View the contents of an unload file
Unload script utility
Add an unload script record
Delete an unload script record
Protect forms from the unload script utility
Purge records with the unload script utility
Run an unload script
Update an unload script record
Validate an unload script record
Purging and archiving records
Unload files
Using datamaps to purge and archive records
Archive records
Purge and archive records
Purge records
Schedule purge and archive processes
Master data records
Add a master data record
Update a master data record
Delete a master data record
Database record auditing
Invoke auditing
Invoke auditing from format control
Invoke auditing from the file in Database Manager (Change Management only)
Start database record auditing
Test Audit Lookup functionality
Audit processing
Determine if a file has audit processing
Audit log file
Open the audit log file
Verify the field name
Verify the file name
Add an audit specifications record
Open the audit specifications table
Define an audit specifications entry
Audit specifications file
Audit specifications file description
The Subroutines form
IR Expert
What is Knowledge Engineering?
Standard record lists and IR Expert
IR query features
IR Expert Options menu
Using IR Expert to create a query
Searching the central Knowledge Base
Promoting or discarding a solution candidate
IR Expert tasks
Access IR Expert
Copy information from a query to a source record
Create an IR Expert query
Enable editing of Knowledge learning records
Enable learning for Knowledge records
Mark an Incident ticket as a solution candidate
Modify an IR Expert query
Promote or delete records in the protocore
Regenerate IR keys
Search the central Knowledge Base
Special considerations for using IR Expert
How IR Expert evaluates documents for relevance
Operations on terms
Lexical analysis
Stemming
Stop words
Spelling correction
Using IR Expert and Adaptive Learning
IR Expert scirexpert file
Creating an IR file
Updates to IR files
Customizing IR Expert for foreign languages
Database Dictionary and IR Expert
IR keys, IR HTML keys, and non-IR keys
Build IR keys and IR HTML keys
Multiple files containing IR keys or IR HTML keys
Find Solution
Access IR Expert
Edit queries for find solution
Chinese and Korean language analyzer
Implement IR searches for foreign language files
Searching for Chinese or Japanese and English words in a Chinese or Japanese environment
Searching for Chinese or Japanese and English words in an English environment
Load data files with IR Expert keys
Start IR asynchronous mode
IR Expert file descriptions
Normals dictionary
Stem dictionary
Stemming example
Stop word file
Suffix file
Record retrieval
The Database Manager utility
Case mode for searching
Change the case mode for searching
Sort order and case mode for searching
Determining System Navigator menu options
Open a record using Database Manager
Record list
Refresh a record list
Edit a record
Multiple-record functions
Adding multiple records
Expand array options
Mass Update
Mass add update function errors
Update multiple records with Mass Update?
Template mass update and required fields
Updating multiple records
Add multiple records using a literal value
Add multiple records using a variable value
Avoid invalid or null key errors
Update multiple records using a literal value
Update multiple records using a variable value
Delete multiple records
Mass Close
Mass close interaction records
Determine the number of records in a record list
Print multiple records
Refresh a record list
Options for mass update
Single-record functions
Add a record
Clear an initial record
Delete a record
Duplicate an existing record
Print a record
Search for newly added records
Set record level options
Update an existing record
Queries
Simple query expressions
Complex query expressions
Logical operators
Relational operators
Starts with relational operator
Equal to relational operator
Less than relational operator
Greater than relational operator
Using ranges in queries
Like relational operator
Wildcard characters
Create a query using not in statements
Create a query using an or statement or an and statement
Use like queries to search for a string of characters
Create a query using an or statement or an and statement
Create a query using array fields
Create a query using more than one field
Perform ir expert queries
Use the equal to relational operator
Use the greater than relational operator
Use the less than relational operator
Use the like relational operator
Use the not symbol with logical or relational operators
Use the starts with relational operator
Create a query using a simple query expression
Create a query using isin in statements
Use the index function in a query
Use the lng function in a query
Use the tod function in a greater than or less than query
Keys in queries
Example: Key selection
Create a query using keys
List: Capability words for partially keyed queries
Recover from record key conflicts
Recover if there are duplicate key errors after changing the case mode
Retrieving records by using the record list method
Retrieve all records in a table
Retrieve record within a range
Retrieving records by using the Query window method
When should I use the Query Window instead of the record list query method?
Excluding records from a query
Using functions in a query
Open the query window
Use the query window
Stored queries
List: Stored query option definitions
Add a stored query
Update a stored query
Append stored queries
Run a stored query
Database performance tuning
Tuning: Improving query speed
Tuning: Number of fields in files
Troubleshooting and tuning queries
Tuning: Fully keyed queries
True queries
Partially keyed queries
Nonkeyed queries
Troubleshooting: Slow execution of queries
Troubleshooting: Query special cases
Running the database maintenance utility
Run the database maintenance utility in foreground (interactively) on Unix
Run the database maintenance utility in background (batch) on Unix
Run the database maintenance utility in foreground (interactively) on Windows
Run the database maintenance utility in background (batch) on Windows
Troubleshooting: Common errors
Messages: Cannot Find SQL Server, Error Connecting to servername
Message: Corresponding Join Not Defined
Messages: Error opening the Core.ir file in read mode
Troubleshooting: Database debug
Troubleshooting: Interpreting debugdbquery output
Troubleshooting: Power outages and hardware failure
Customer Support
HP Support matrices
Documentation Home
HP Service Manager Documentation
English-to-Russian translation