Lucent Technologies Intuity CONVERSANT System Version 7.0 Guide

6  
Database Administration  Decrease Database Storage Size
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 367
12  
Enter exit
Note:We recommend that you use the above commands as written. 
However, if you are concerned about the /oracle file system size, 
substitute the command, 
add datafile ‘/home2/dbsA2.dbf’ 
for 
add datafile ‘/oracle/dbs/dbsA2.dbf’ 
13  
Enter /vs/bin/util/dbfrag
The system displays the number of free database blocks.
14  
Check that the...

6  
Database Administration  Decrease Database Storage Size
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 368
Reduce the Amount of Call Data Stored
You can decrease the amount of database space needed by reducing the 
number of stored call data events. This reduction must be accomplished at 
the application design level. Unlike Reduce the Number of Days Data Is 
Stored, there are no system variables to modify. This minimization technique 
involves modifying...

6  
Database Administration  Decrease Database Storage Size
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 369
then 
:
else
 ulimit 2113674; ior w 
fi
# perform the cron jobs
$VSUTIL/cdhsum
$VSUTIL/cdhdel
$VSUTIL/ccasum
$VSUTIL/ccadel
# cleanout the unwanted ORACLE log files
$VSUTIL/logdel
Change the Data Storage Number of Days
Currently, the only report produced for the call classification data is the Call 
Classification Summary report. Therefore, saving zero...

6  
Database Administration  Decrease Database Storage Size
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 370
To change the number of data days, modify the following commands in the 
croncdh file, where 
x is the number of days of data to store:
$VSUTIL/cdhdel -
x
$VSUTIL/ccadel -
x
Note:If cdhdel and ccadel do not have any arguments, the default of 
seven days is used, as illustrated in the sample croncdh file in 
Reduce the Number of Days Data Is Stored
 on...

6  
Database Administration  Increase Shared Pool Size
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 371
$VSUTIL/cdhsum
$VSUTIL/cdhdel -2
$VSUTIL/ccasum
$VSUTIL/ccadel -4
# cleanout the unwanted ORACLE files
$VSUTIL/logdel
/vs/bin/util/dbcheck -w 15,20
Increase Shared Pool Size
Perform this procedure to allocate additional memory resources for ORACLE. 
You may need to do this if trying to write to several database tables at once 
and you receive the ORACLE error...

6  
Database Administration  Rollback Segment
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 372
5  
Save and exit the file.
6  
Enter /oracle/bin/ior c to stop the database system.
7  
Enter /oracle/bin/ior w to start the database system.
Rollback Segment
A rollback segment is a storage buffer that records actions that can be 
undone under certain circumstances. The rollback segment grows as needed 
as long as there is available space in the database. However,...

6  
Database Administration  Rollback Segment
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 373
Verify or Reduce the Size of the Rollback Segment
Note:The procedure to reduce the size of the R1 rollback segment 
requires that the voice system and the database system be 
stopped. If possible, avoid reducing the size of the rollback 
segment when call traffic is heavy. The procedure to verify the size 
of the rollback segment does not require that the voice system...

6  
Database Administration  Rollback Segment
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 374
The original size of the rollback segment was set to 653312 bytes. If the 
current size is close to this number, or if it is less than 1/4 of your total 
database size, you do not need to reduce the size of the rollback 
segment.~
To terminate this procedure, go to step 4
.
~
To continue with this procedure and reduce the size of the rollback 
segment, go to step 5
....

6  
Database Administration  Rollback Segment
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 375
6  
Enter y to shut down the voice system and continue with the procedure to 
reduce the size of the rollback segment.
The system displays the following message if the database system is 
running:The database system is running. Is it OK to shutdown the 
database? (y/n)
7  Enter y
The system stops the database system and executes the rb_init 
command.
When the rb_init...

6  
Database Administration  Voice System Database Administration
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 376
Voice System Database Administration
Use the following procedure to access the Database Administration window:1  
At the 
Console Login:
 prompt, enter root
The system prompts you for a password.
2  
Enter your root password.
The system displays the system prompt 
#.
3  
Enter cvis_menu
The system displays the Voice System Administration menu...