Hi,
we use Sybase on UNIX, so I don't know if this helps but...
First, SQL Backtrack, IMHO, is not production software.
We dump ALL the databases to a filesystem, then backup the filesystem and
database dumps as regular files, it works very well. However I have the benefit
of a high speed network (SP switch) and 32x18GB disks for the filesystem (RAID
0). The filesystem is NFS mounted.
I know on UNIX Sybase can only create 32 stripes and each stripe is limited to
2 GB - IF your using a 32-bit version, ie. v11. So won't help you, IF your on
v11.
For performance I can dump 20MB/s to a local array, 10MB/s to NFS.
Let me know if you need more info.
Miles
-------------------------------------------------------------------------------------------
----------------
Miles Purdy
Miles Purdy
System Manager
Farm Income Programs Directorate
Winnipeg, MB, CA
purdym AT fipd.gc DOT ca
ph: (204) 984-1602 fax: (204) 983-7557
-------------------------------------------------------------------------------------------
----------------
>>> puimym AT HK1.IBM DOT COM 22-Oct-01 4:33:10 AM >>>
>>> puimym AT HK1.IBM DOT COM 22-Oct-01 4:33:10 AM >>>
Hi TSMers,
Is there anyone has experience on TSM with Sybase?
We have a customer with 200GB data on Sybase (NT platform). As we have
checked, SQL Backtrack and OBSI module for ADSM couldn't work with the
LAN-free backup of TSM, so we want to propose online dump DB method, then
will use TSM's LAN-free backup with the intermediate file created. Does
anyone has this experience that can share as we concern with the
performance of dumping 200GB? Thanks.
Best Regards,
Molly Pui
I/T Specialist
Tivoli Systems, IBM China/Hong Kong Limited
Email: puimym AT hk1.ibm DOT com
|
