Re: SQL1084C

Dan Behman <[email protected]> Thu, 2 Mar 2006 14:41:17 -0500
Newsgroups gmane.linux.suse.db2
Message-ID <OFD18BA5F6.AF3D9DFC-ON85257125.006BE6F0-85257125.006C266A@ca.ibm.com>
Hi,

SQL1084C means that there is problem allocating the shared memory segment.
Check your /proc/sys/kernel/shmmax setting and ensure it set sufficiently
high - 2GB would be a good value to use.  Also ensure you add that to your
/etc/sysctl.conf to ensure it survives reboots.

----------
Dan Behman
DB2 UDB CE Development, OSS
IBM Software Development Lab
----------


"Bright Kasimani" <[email protected]> wrote on 03/02/2006 02:28:04 PM:

> Hi,
> I am facing a weird problem with DB2 UDB V8.2 in Linux for p-Series.
> We are trying to load the datawarehouse tables in DB2 UDB v8.2 on Linux
for
> p-Series.
> The ETL tool used is IBM Data Stage - Server installed in Windows XP.
> We are trying to load 1,000,000 records.
> The database gets shutdown frequently and the db2diag.log displays
SQL1084C.
> There are no other information in the log.
> Can anyone help me to identify the problem?
>
> Regards...bright