Sybase IQ backup Method

[former_member246062]

Hello ,

Using Sybase IQ 16.1 SP02 PL08 ,

• Total DB Size - 45 TB ,
• Multiplex - 3 nodes ,
• 10 RAW DEVICES for IQ MAIN
• All on Vitual Machine

Here all ETL procedures does DDLs and we had to take ETL downtime for triggering the backups. Its impossible to hold the system for more than 3 hours.

What will be the preferrable way to take the backup.

Infra Team also not sure of using which backup methodologies to accomplish the backup.

[former_member667370]

First - Tried normal native backup in IQ, but failed due to continuous DDL changes in ETL jobs. Since the DB is of 50 TB and it is not feasible to hold jobs for longer hour and take this backup.

Second - Since it is on Multiplex environment with 80+ shared devices on VMs, infra team having difficulty doing device copies.

---We are planning to migrate the landscape to normal/physical server storage model bcoz of backup limitations. Any suggestions pls.

query out of this context :

Any limitations in supporting number of device partitions with 5 different multiplex nodes in VM . Currently we are using 82 devices (RAW LUNS) for IQ_MAIN.

Any upper limit on this devices?

Also any upper limit for how many multiplex nodes can share the partitions?

Thanks,

Yuvaraj Subramani

[markmumy]

You have a few choices.

First, you can use the BACKUP statement to have IQ dump the IQ database to a filesystem, or filesystems, that the coordinator has access to. This is what I call an internal backup, one that is run by IQ.

Second, you could use the BACKUP statement to have IQ launch an external utility to copy the devices. This is what we call a virtual backup. This method can be faster, but it uses more space. Generally, the external utilities copy the entire IQ main devices. If the device is sized at 1TB, but only has 100GB of data in it, this will backup all 1TB. A normal backup will only copy the 100GB in use.

The virtual backup can use any utility to copy the IQ main store devices. Any utility. OS commands like dd, tar, cpio, etc. You can also use any storage level commands like those that are delivered with the likes of EMC, NetApp, HP, 3Par, IBM, Tivoli, and Veritas.

The larger IQ customers tend to use the virtual backup as it provides the most flexibility. With either method you can back up while IQ is running and processing data.

Mark