Join / Log in
Try –b. Commvault uses onbar AFAIK. You used –b in the restore command
The same thing, I suppose archecker is quicker as onbar is just a wrapper but you would never be able to measure the difference
IBM Informix Dynamic Server Version 12.10.FC10
Program Name: archecker
Released: 2017-10-23 13:02:19
CSDK: IBM Informix CSDK Version 4.10
ESQL: IBM Informix-ESQL Version 4.10.FC9
Compiled: 10/23/17 13:02 on Linux 2.6.18-128.el5 #1 SMP Wed Dec 17 11:41:38 EST 2008
AC_TAPEBLOCK 62 KB
Control page checks PASSED
Table checks PASSED
Tables/Fragments validated: 0
onbar is starting ..........
Galaxy Instance: Instance001
Loading Library:/opt/commvault/Base64/libCvIbsad.so from dir /opt/commvault/Base64
Get object = /ids1/rootdbs/0
Data transfer Complete, total = 91613184 bytes
File /ids1/rootdbs/0.1612897233.27085 Size = 91613184 bytes, Informix I/O Time = 7.337244 secs, MA I/O Time = 0.374616 secs, Total I/O Time = 7.711860 secs,Informix Throughput = 41.862740 GB/Hr, MA I/O Throughput = 819.925297 GB/Hr, Total I/O Throughput = 39.829190 GB/Hr
Get object = /ids1/dblog/0
Data transfer Complete, total = 63488 bytes
File /ids1/dblog/0.1612911854.27085 Size = 63488 bytes, Informix I/O Time = 0.000130 secs, MA I/O Time = 0.139186 secs, Total I/O Time = 0.139316 secs,Informix Throughput = 1637.385442 GB/Hr, MA I/O Throughput = 1.529321 GB/Hr, Total I/O Throughput = 1.527894 GB/Hr
I have a customer at which we tested Commvault direct to onbar, but at the end it remained very slow even playing with onbar onconfig parameters.At the end we decided to use PSM, then comvault takes the PSM files as normal file systems. => backup is done much quicker and you depend less on Commvault to restore.
The caveat of this method is that you need more file system space if you want to keep several backup generations on line
In general, backing up to a Enterprise backup system like Commvault may save money to the company, but when it comes to restoring, Informix becomes one client among many clients in the company and you may be very disappointed in terms of priority for restoring. This happened at another customer where he had to wait for hours before he could restore his backup, because other clients were backing up at this time...
Backing up with PSM on local FS then push to Enterprise system later may offer more versatility.
Totally agree, back up to local disk first and the get Commvault or whatever to pick up the files.
My real-world example was the company that lost the Enterprise backup server and it took 3 days to get it rebuild and fully functional. And of course when this happened they also needed a production restore. Kinda ironic that the company was down for over a day cos their backup system failed.
So I ran for test a validation on only one dbspace (dbsb), its size is 581 GB and it took apparently about 12 hours!!
Is this representing the time that a restore could take?
Just a question about the result… I can see "Data transfer Complete, total = 581776986112 bytes"
But I would expect "Data verification Complete…"
This means that all is OK?
ids1:/IDS/informix$onbar -v dbsb
Get object = /ids1/dbsb/0
Data transfer Complete, total = 581776986112 bytes
File /ids1/dbsb/0.1612897235.27085 Size = 581776986112 bytes, Informix I/O Time = 45812.253628 secs, MA I/O Time = 909.040381 secs, Total I/O Time = 46721.294009 secs,Informix Throughput = 42.577241 GB/Hr, MA I/O Throughput = 2145.734542 GB/Hr, Total I/O Throughput = 41.748830 GB/Hr
About the PSM, I have to start from here ?