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