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