Re: "too many tables locked"
In article: <447499$3vf$1@mhafn.production.compuserve.com> Patrick Soehl
<102121.3564@CompuServe.COM> writes:
>
> I get this message when I run dbload. I have a command file with
> the
>
> FILE a.unl DELIMITER "|" 10;
> INSERT INTO a;>
> It gets to about 50 tables and aborts with the
> "too many tables locked" message. I have 270 tables I'm trying
> load. I've raised my TBLSPACES parameter to 500. Do I just need
> to break this up into smaller pieces?
Patrick,
Are you just using one .cmd file to load all your tables? I can't
understand *why* it would keep a table it had finished loading open if
this is the case, but if so, you have two options:
1. open the database in exclusive mode and LOAD the tables from SQL, or
2. use spearate command files and multiple DBLOAD commands.
Also, you might want to check your kernel parameters.
Just to clarify for Mr Burnore, these are probably not the only two
ways around the problem, they're my two suggestions for discussion, my
$0.02 worth.
HTH,
--
Cheers,
+---------------------------------------------------------------------------+
| Spokey the Wheeler |
+---------------------------------------------------------------------------+
INCLUDE "Disclaimer.4gh" -- my opinions are
INCLUDE "FlamesToDevNull.4gh" -- tells flamers where to go
INCLUDE "BillyBoyDasAufregendAndereKondom.4gh" -- header file for this class