home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1992 #27 / NN_1992_27.iso / spool / comp / database / informix / 2509 < prev    next >
Encoding:
Internet Message Format  |  1992-11-24  |  3.7 KB
  1. Path: sparky!uunet!cs.utexas.edu!swrinde!emory!emory!not-for-mail
  2. From: inf_bb@hermes1.sps.mot.com (informix users bb)
  3. Newsgroups: comp.databases.informix
  4. Subject: page cleaners time out
  5. Date: 23 Nov 1992 19:18:07 -0500
  6. Organization: Mailing List Gateway
  7. Lines: 67
  8. Sender: walt@mathcs.emory.edu
  9. Distribution: world
  10. Message-ID: <1ersbvINN729@emory.mathcs.emory.edu>
  11. Reply-To: inf_bb@hermes1.sps.mot.com (informix users bb)
  12. NNTP-Posting-Host: emory.mathcs.emory.edu
  13. X-Informix-List-ID: <list.1638>
  14.  
  15.  
  16. we are running online ver 5.00.UC2 with i-star and are experiencing a  
  17. problem with the page cleaners timing out.  we are running on a sun
  18. 690 with the database accelerator kernal enhancement.  
  19.  
  20. a tbstat -u gives the following:
  21.  
  22. (hermes1)/home_hermes1/baskett>tbstat -u
  23.  
  24. RSAM Version 5.00.UC2   -- On-Line -- Up 08:17:49 -- 31856 Kbytes
  25.  
  26. Users
  27. address  flags   pid     user     tty      wait     tout locks nreads   nwrites
  28. 10001ba8 ------D 12325   root     ttyp5    0        0    0     1384     247
  29. 10001c18 ------D 0       root     ttyp5    0        0    0     0        0
  30. 10001c88 ------F 12349   root              0        0    0     0        0
  31. 10001cf8 ------F 0       root              0        0    0     0        0
  32. 10001d68 ------F 0       root              0        0    0     0        0
  33. 10001dd8 ------F 0       root              0        0    0     0        0
  34. 10001e48 ------F 12353   root              0        0    0     0        0
  35. 10001eb8 ------F 12354   root              0        0    0     0        0
  36. 10001f28 ------F 12355   root              0        0    0     0        0
  37. 10001f98 ------F 0       root              0        0    0     0        0
  38. 10002008 ------F 12357   root              0        0    0     0        0
  39. 10002078 ------F 12358   root              0        0    0     0        0
  40. 100023f8 ------- 13354   germano  -        0        0    1     0        0
  41. 10002468 ------- 657     wingz    ttypd    0        0    3     73       0
  42. 100024d8 ------- 10770   zill     ttyq9    0        0    2     25       0
  43.  15 active, 100 total
  44.  
  45. Transactions
  46. address  flags user     locks log begin isolation retrys coordinator       
  47. 10004768 A---- 10001ba8 0     0         NOTRANS   0                        
  48. 1000493c A---- 10001c18 0     0         NOTRANS   0                        
  49. 100057dc A---- 100024d8 2     0         NOTRANS   0                        
  50. 100059b0 A---- 10002468 3     0         NOTRANS   0                        
  51. 10005f2c A---- 100023f8 1     0         NOTRANS   0                        
  52.  5 active, 100 total
  53.  
  54. looking at the online log:
  55.  
  56.  
  57. Mon Nov 23 00:14:33 1992
  58.  
  59. 00:14:33  ERROR: page cleaner # 8 has timed out
  60. 00:15:02  Checkpoint Completed
  61. 00:31:34  ERROR: page cleaner # 2 has timed out
  62. 00:31:50  Checkpoint Completed
  63. 00:48:21  ERROR: page cleaner # 3 has timed out
  64. 00:49:01  Checkpoint Completed
  65. 01:04:47  Checkpoint Completed
  66. 01:20:09  ERROR: page cleaner # 4 has timed out
  67. 01:20:25  Checkpoint Completed
  68. 01:37:47  Checkpoint Completed
  69.  
  70. does anyone know what is causing this? seen this before? any fixes? 
  71. i havent posed this question to tech support yet.
  72.  
  73. ------------------------------------------------------------------------------
  74.                                                             |     .     .
  75.   Bob Baskett                                               |    ...   ...
  76.   Software Engineer, DBA                                    |   ..... .....
  77.   Business Systems Integration Group                        |  ..   ...   ..
  78.   Semiconductor Products Sector                             | .      .      .
  79.   Mesa, AZ                                                  |
  80.                                                             |  Motorola, Inc
  81. ------------------------------------------------------------------------------
  82.