IDS Forum

Re: Logical log backup SLOW to NetBackup

Posted By: Fernando Nunes
Date: Tuesday, 3 May 2011, at 5:35 p.m.

In Response To: Logical log backup SLOW to NetBackup (SCOTT YOHONN)

What is the opinion of the SM supplier?
Informix uses a public interface (XBSA) and I would expect it to call the
same API functions independently of the SM.
Note that the XBSA implementation is done inside the XBSA library which is
specific for every SM.
Why does the "resource" take so long to be obtained?
Unfortunately I've seen this with the same SM, I raised the issue inside the
customer team but things haven't improved. It takes much longer to establish
the connection than to transfer the data... for me, personally, this is a
bit hard to accept. And please remember the effect of this if you need to
restore with logs...
It will greatly increase the recovery time.
I would love to see some answers for this issue....
Regards

On Tue, May 3, 2011 at 2:20 PM, SCOTT YOHONN <syohonn@gmail.com> wrote:

> We are in the process of changing our enterprise backup solution from
> Tivoli
> Storage manager (TSM) to Symantec NetBackup (NBU). Our Informix logical
> logs
> average about 32mb in size and are able to backup to TSM in 5 seconds or
> less.
> The Informix databases that have been converted to NBU take MUCH longer to
> backup logical logs (1 – 3 minutes/logical log) and can’t keep up. I would
> prefer not to change the size or number of the logical logs to work around
> this problem, but it might be inevitable with NBU.
> The actual read/write of a logical log backup to NBU only takes seconds. It
> appears that most of the time to backup a logical log in NBU occurs during
> the
> phase in which the backup process “requests a resource” and then is granted
> a
> resource for the backup of each logical log (see example below). Does
> anyone
> have any experience with making a persistent connection for Informix
> logical
> logs to NBU so that each logical log backup does NOT need to establish a
> new
> connection to NBU each time for a backup? Also, does anyone know how
> Informix
> spawns processes for logical log backups? Specifically, as transactions
> progress through various logical logs, does Informix spawn separate backup
> processes for each logical log or is only one logical log backed up at a
> time?
>
> 05/02/2011 05:43:13 - requesting resource NBU_DISK_Archive_SUG
> 05/02/2011 05:43:13 - requesting resource
> nbu_master.acmeco.com.NBU_CLIENT.MAXJOBS.node.acmeco.com
> 05/02/2011 05:43:13 - requesting resource
> nbu_master.acmeco.com.NBU_POLICY.MAXJOBS.Informix_Logs_RDC_Prod
> 05/02/2011 05:46:47 - granted resource
> nbu_master.acmeco.com.NBU_CLIENT.MAXJOBS.node.acmeco.com
> 05/02/2011 05:46:47 - granted resource
> nbu_master.acmeco.com.NBU_POLICY.MAXJOBS.Informix_Logs_RDC_Prod
> 05/02/2011 05:46:47 - granted resource
>
> MediaID=@aaaaB;DiskVolume=/nbu_archive1;DiskPool=node_AD_Archive;Path=/nbu_archive1;StorageServer=
> node.acmeco.com;MediaServer=node.acmeco.com
> 05/02/2011 05:46:47 - granted resource node-Disk-Archive
> 05/02/2011 05:46:48 - estimated 0 kbytes needed
> 05/02/2011 05:46:52 - started process bpbrm (pid=5953)
> 05/02/2011 05:46:56 - connecting
> 05/02/2011 05:47:07 - connected; connect time: 0:00:00
> 05/02/2011 05:47:12 - begin writing
> 05/02/2011 05:47:24 - end writing; write time: 0:00:12
> the requested operation was successfully completed (0)
>
> Thanks,
> Scott
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

--0016e68e8026b812f404a265e9af

Messages In This Thread

• Logical log backup SLOW to NetBackup
  SCOTT YOHONN -- Tuesday, 3 May 2011, at 9:20 a.m.
  • Re: Logical log backup SLOW to NetBackup
    KARL OLIVER -- Tuesday, 3 May 2011, at 4:15 p.m.
  • Re: Logical log backup SLOW to NetBackup
    Fernando Nunes -- Tuesday, 3 May 2011, at 5:35 p.m.
    • Re: Logical log backup SLOW to NetBackup
      SCOTT YOHONN -- Friday, 13 May 2011, at 10:32 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.