ON-LINE 7.13 crash and some other problems, help 
Author Message
 ON-LINE 7.13 crash and some other problems, help

Hi net,
We have a production DB, 700 stored procedures. We have some problems.
1, sometimes, the performance will suddenly drop.
   using "onstat -g seg" to check, found out memory is not enough,
   so I use "onmode -F" to release some memory, but the DB crash!!

2, can anyone tell me how to use "violations mode"?
      I want to take advantage of Column Constraint, when I insert a record
      to table A, when the record against the column constraint of table A,
      like duplicate kye value, then I want to insert this record into another
      table B with a sequence number and an integer to indicate how often
      this violation has happened.

3, How to cacaulate the extent size and how to set the fragmentation
      properly?

if possible, please e-mail me.      Thanks in advance.

Jack



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. OnLine 7.13 performance problems - comments please?

2. Online 7.13 UC1 on HP-UX 10.10

3. Online 7.13 error 25588

4. Online 7.13 UC1 on HP-UX 10.10 -Reply

5. Freed logical log files Online 7.13 UC3

6. Checkpoints in online 7.13

7. ONLINE 7.13 UC1 and PDQ

8. HP9000 and ONLINE 7.13

9. HP9000 and ONLINE 7.13

10. MIGRATING 4GL'S TO ONLINE 7.13

11. Solaris 2.5 and OnLine 7.13

12. online 7.13 performance(with 2 CPUs)??


 
Powered by phpBB® Forum Software