Filter
Top Products
Contents
Issue 1.0 April 2006 35
Database problems
If you are using databases on the LAN, communications problems with those databases may
affect voice operations. Troubleshooting database server disconnections
on page 38 covers
what to do when the IR system is not communicating with the database server at all. The
following topics explain how to check on less serious problems with databases.
Checking JDBC operations
Use the following commands to check JDBC function:
• netstat -a lists port usage. Review the output to verify that ports are functioning and
are not overloaded.
• trace chan all DBDIP3 traces DIP activity. Review the output to verify that all DIPs
are functioning in the desired way.
Review the following system processes related to JDBC operations:
• /vs/bin/vrs/idbcint DIP num
• /vs/bin/vrs/jdbcdip dipnumber
• /usr/bin/../java/bin/../bin/SPARC/routine_threads/java -Dpname=ais3 -cp /webadm
• /usr/bin/../java/bin/../bin/SPARC/routine_threads/java -Dpname=ais(dip number) -cp
/webadm
Checking Oracle object size limits
An extent is a user-defined unit of storage in the Oracle storage clause used when defining
an Oracle object. It is used as MINEXTENTS or MAXEXTENTS in the storage clause. An
Oracle object (that is, a table, an index, a rollback segment) grows one extent in size each
time the object needs to be expanded.
When the maximum allowed number of extents is reached, the object will not be able to grow
further. The object needs to be redefined so that either the size of each extent is increased or
the initial object size is increased, to reduce the number of extents required for the storage of
this object. The maximum allowed number of extents in a system is 2,147,483,645.
To check the number of extents:
1. Type dbused and press Enter.
The system displays the Space Allocated screen.
2. Compare the value in the EXTENTS column to the value in the MAX_EXTENTS column.
If the value in the EXTENTS column is greater than or equal to the value in the
MAX_EXTENTS column, the table has reached its maximum size.