HP Service Manager: Database Administration

• 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

• English-to-Russian translation