SAP Mix

RE: Informix Backup with Veritas Netbackup

Posted By:
Date:

We faced same problem on out production system. we were getting error "Lock
table overflow - user id 3200", we added more locks at database level, but
it was giving same. Finally we find out which job is taking more locks and
modified the job. I am not abaper, but as I remember it was problem of
commit. frequency of commit was very less in that programm.

I hope this will you.

Regards
Rajesh Kokane

-----Original Message-----
From: Krijt, Marco [mailto:Marco.Krijt@VendexKBB-ITS.nl]
Sent: Thursday, February 27, 2003 1:41 AM
To: sapmix@iiug.org
Subject: RE: Informix Backup with Veritas Netbackup [48]


Are you sure the backup took up the locks, and not another programm,
which was calling the failuer of netbackup.

We use also netbackup and onbar to backup.
But I don't know how many locks he needs,
but I tink it is not that many.

We run only full backups online (so no incrementals).

I can imagine that another programm took all the locks,
after that al other sessions can be killed with
the meaning "No mor locks available",
but if you get this error, the problem can be al other
programm which took all the locks.

Se another mail from me tonight:
We have also 2000000 locks on a database of 1,1TB.
If it is not enough, I say always to look to the ABAP-programm,
or the variant.

Sometimes programms have build in a commit, if a job fails or make to many
locks the commit interval has to be reduced in the ABAP-programm (or
sometimes variant).

We have already 2000000 locks for many years, and it works fine.

With onstat -u, you can see which proces has many locks.
We also are called by phone automatically if more then 1000000 locks are in
use
(for 24 hours a day.)

Then we look with:
onstat -u to the locks and the SID,
then we look to onstat -g ses|grep <SID> and get the PID
You can see the PID back in SM66/SM50.
We tell it to the user (at office hours) and kill the SID with onmode -z or
use SM66/SM50.
If with onstat -u the third caracter is a R the transaction is rolling back
and will not take any locks any more, After the rollback (sometimes hours)
the problem is solved.

If you wait to long to kill the SAP-proces al other programms will be
failing with,
"no more locks available" and that's a pitty, so be on time, that's nicer.

> Marco Krijt
> Medewerker Operationeel Beheer SAP
> Vendex KBB IT Services b.v.
> Frankemaheerd 6
> 1102 AN Amsterdam Z.O.
> Postbus 12644
> 1100 AP Amsterdam Z.O.
> Tel: +31 (0)20-3129254
> E-mail: marco.krijt@vendexkbb-its.nl
>



-----Oorspronkelijk bericht-----
Van: Chang, Nicole [mailto:changn@tycoelectronics.com]
Verzonden: woensdag 26 februari 2003 20:11
Aan: sapmix@iiug.org
Onderwerp: RE: Informix Backup with Veritas Netbackup [44]


No, I did not mix up the terms. I was attempting to do a whole database
backup, and my online log file as well as my bar act file showed that I ran
out of database locks (isam 134)

My logical logs at that poing were fine.

-----Original Message-----
From: Janusz Wojnarowicz [mailto:janusz.wojnarowicz@de.ibm.com]
Sent: Wednesday, February 26, 2003 12:11 PM
To: Chang, Nicole
Cc: forum.subscriber@iiug.org; sapmix@iiug.org
Subject: Re: Informix Backup with Veritas Netbackup [42]


Well, I'm afraid you mixed up two terms e.g. "lock" and "log".
You can backup only logical LOGS and not LOCKS. LOCK is a configuration
performance parameter in ONCONFIG.
Performing a backup you will have the logical logs with complete Informix
instance, as well.
But you can also backup your logical logs separately if you wish.

Regards,
Janusz.
______________________________________________________________________
Janusz Wojnarowicz mailto:Janusz.Wojnarowicz@de.ibm.com
Development Engineer phone: ++49 6227 7 42755
IBM Informix Technology Center @ SAP fax: ++49 6227 7 47147
c/o SAP AG TechDev 05
Neurottstr. 16
D-69190 Walldorf





"Chang, Nicole"

<changn@tycoelect To: sapmix@iiug.org

ronics.com> cc:

Sent by: Subject: Informix Backup
with Veritas Netbackup [42]
forum.subscriber@

iiug.org





26.02.2003 15:47






Hello,

I hope someone out there can shed some light into this. I just attempted
to
run a backup with netbackup, but the backup took up all of the available
locks. My onconfig file locks parameter is set to 2 million locks.

And although we were trying to run a backup during business hours, ours is
a
production system that is also hit heavily at night because of running
batch
jobs.

Can anyone tell me why I ran out of locks and if there are any onconfig
parameters I need to change?

Thank you in advance.

Nicole Chang
Database Analyst
M/A-COM, A Tyco International Company
978-442-4389

Messages In This Thread

• RE: Informix Backup with Veritas Netbackup
  -- Wednesday, 26 February 2003, at 11:21 p.m.

SAP Mix is maintained by Administrator with WebBBS 5.12.