数据和日志分离问题

donniejeck 发表于 2008-07-25 10:15

OS:WINDOWS 2003+SP2
ASE:12.53

1> sp_helpdb DSOA
2> go
name                   db_size    owner                dbid
      created
      status

------------------------ ------------- ------------------------ ------
      --------------
      ----------------------------------------------------------------------
-------------------------------
DSOA                      33002.0 MB sa                         4
      Jul 17, 2008
      select into/bulkcopy/pllsort, abort tran on log full

(1 row affected)
device_fragments             size       usage
      created          free kbytes
------------------------------ ------------- --------------------
      ------------------- ----------------
master                            2.0 MB data only
      Jul 17 20085:32PM             0
oadb                            1998.0 MB data only
      Jul 17 20085:32PM       209590
oadb                            500.0 MB data only
      Jul 17 20085:32PM       510000
oadb                            6502.0 MB data only
      Jul 17 20085:32PM       169774
oadb1                            9000.0 MB data only
      Jul 17 20085:32PM       3785388
oadb2                            2998.0 MB data only
      Jul 17 20085:32PM       2389010
oadb2                            5000.0 MB data only
      Jul 17 20085:32PM       5100000
oadb2                            1002.0 MB data only
      Jul 17 20085:32PM       1022040
oadb_log                         6000.0 MB log only
      Jul 17 20085:32PM not applicable

--------------------------------------------------------------
log only free kbytes = 6119996
(return status = 0)
1> use DSOA
2> go
1> sp_helplog
2> go
In database 'DSOA', the log starts on device 'oadb_log'.
(return status = 0)

donniejeck 发表于 2008-07-25 10:16

而SYBASE控制台显示结果却不同

请见截图

donniejeck 发表于 2008-07-25 10:17

1> select * from master..sysusages
2> go
dbid segmap    lstart    size    vstart    pad unreservedpgs
      crdate
------ ----------- ----------- ----------- ----------- ------ -------------
      --------------------------
   1       7       0    3072       4 NULL       813
            Jul 17 20084:26PM
   1       7    3072    20480    6660 NULL       20400
            Jul 17 20084:46PM
   2       4       0    1536    4100 NULL       925
            Jul 17 20084:26PM
   2       7    1536    102400 100663296 NULL    102000
            Jul 17 20084:47PM
   3       7       0    1024    3076 NULL       415
            Jul 17 20084:26PM
   4       0       0    1024    27140 NULL          0
            Jul 17 20085:32PM
   4       3    1024 1022976 33554432 NULL    104795
            Jul 17 20085:32PM
   4       0 1024000    256000 34577408 NULL    255000
            Jul 17 20085:32PM
   4       3 1280000 3329024 34833408 NULL       84887
            Jul 17 20085:32PM
   4       3 4609024 4608000 50331648 NULL    1892694
            Jul 17 20085:32PM
   4       3 9217024 1534976 67108864 NULL    1194505
            Jul 17 20085:32PM
   4       0 10752000 2560000 68643840 NULL    2550000
            Jul 17 20085:32PM
   4       3 13312000    513024 71203840 NULL    511020
            Jul 17 20085:32PM
   4       4 13825024 3072000 83886080 NULL    3059984
            Jul 17 20085:32PM
31513       7       0    1024    5636 NULL       391
            Jul 17 20084:26PM
31514       7       0    61440 16777216 NULL       34067
            Jul 17 20084:26PM

(16 rows affected)

donniejeck 发表于 2008-07-25 10:19

1> select * from master..sysdatabases
2> go
name                         dbid suid    status version logptr
      crdate                   dumptrdate             status2
      audflags deftabaud defvwaud defpraud def_remote_type
      def_remote_loc

      status3 status4
------------------------------ ------ ----------- ------ ------- -----------
      -------------------------- -------------------------- -------
      ----------- ----------- ----------- ----------- ---------------
      -----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------
      ----------- -----------
DSOA                            4       1    4    1 13825063
            Jul 17 20084:49PM    Jul 25 20089:37AM    1
               0       0       0       0          NULL
      NULL

               0       0
master                            1       1    0    1    3003
            Jul 17 20084:26PM    Jul 17 20084:44PM-32768
               0       0       0       0          NULL
      NULL

               0       0
model                            3       1    0    1       624
            Jul 17 20084:26PM    Jul 17 20084:27PM-32768
               0       0       0       0          NULL
      NULL

               0       0
sybsystemdb                   31513       1    0    1       632
            Jul 17 20084:26PM    Jul 17 20084:44PM-32768
               0       0       0       0          NULL
      NULL

               0       0
sybsystemprocs                31514       1    8    1    28548
            Jul 17 20084:26PM    Jul 17 20084:45PM-32768
               0       0       0       0          NULL
      NULL

               0       0
tempdb                            2       1 12    1       662
            Jul 25 20089:39AM    Jul 25 20089:57AM-32768
               0       0       0       0          NULL
      NULL

               0       0

(6 rows affected)

cctvdd 发表于 2008-07-26 09:15

WINDOWS 2003 下运行好像不是很稳定样呢

donniejeck 发表于 2008-07-28 09:18

OS应该还是很稳定的.问题出在ASE对于系统表sysusages的segmap的值为0无法判断是数据还是日志.

页: [1]

Chinaunix's Archiver

数据和日志分离问题

而SYBASE控制台显示结果却不同