Using large raw partitions with Replication Serv

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Using large raw partitions with Replication Server on Unix in Sybase

It is a good practice with production installations of Replication Server on Unix that you use raw partitions for the stable devices. This is for just the same reason that production ASE's use raw partitions. Raw devices can be a maximum of 2GB with replication server up to release 11.5. (I have not checked 12.)

In order to utilise a raw partition that is greater than 2GB in size you can do the following (remember all of the cautionary warnings about trying this sort of stuff out in development first!):

add partition firstpartition on '/dev/rdsk/c0t0d0s0' with size 2024
go
add partition secondpartition on '/dev/rdsk/c0t0d0s0' with size 2024
starting at 2048
go


Notice that the initial partition is sized at 2024MB and not 2048. I have not found this in the documentation, but replication certainly seems to have a problem allocating a full 2GB. Interestingly, do the same operation through Rep Server Manager and Sybase central caused no problems at all.

(Continued on next question...)

Other Job Interview Questions

• Explain about the Data integration suite features?
• Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
• Does Table Partitioning Require User-Defined Segments in Sybase?
• We have lost the sa password, what can we do?
• Hiding your password to isql in Sybase
• Explain about the Data integration suite features?
• What is the Difference Between Replication Server and SQL Remote in Sybase?
• Why place tempdb and log on low numbered devices?
• What is the best value for cschedspins?
• How to replicate col = col + 1 in Sybase ?
• More...