Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Error 1009134 : Insufficient buffers for 'insert..select'.

2 posts in General Discussion Last posting was on 2012-04-11 04:42:33.0Z
Abhilash Posted on 2012-03-21 16:35:05.0Z
Sender: 5533.4f69f718.1804289383@sybase.com
From: Abhilash
Newsgroups: sybase.public.iq
Subject: Error 1009134 : Insufficient buffers for 'insert..select'.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f6a0339.5709.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 21 Mar 2012 08:35:05 -0800
X-Trace: forums-1-dub 1332347705 172.20.134.41 (21 Mar 2012 08:35:05 -0800)
X-Original-Trace: 21 Mar 2012 08:35:05 -0800, 172.20.134.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4477
Article PK: 246617

Any idea about the error "1009134 Insufficient buffers for
'insert..select'."? In what scenario this can happen?
I have 2GB cache configured for main & temp cache and 100GB
temp dbspace. I am using Sybase IQ 15.3 in windows
environment.

Thanks in advance.


Manish Negandhi [TeamSybase] Posted on 2012-04-11 04:42:33.0Z
From: "Manish Negandhi [TeamSybase]" <nospam_negandhi.manish@gmail.com>
Newsgroups: sybase.public.iq
References: <4f6a0339.5709.1681692777@sybase.com>
Subject: Re: Error 1009134 : Insufficient buffers for 'insert..select'.
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3664
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3664
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f850bb9@forums-1-dub>
Date: 10 Apr 2012 21:42:33 -0700
X-Trace: forums-1-dub 1334119353 10.22.241.152 (10 Apr 2012 21:42:33 -0700)
X-Original-Trace: 10 Apr 2012 21:42:33 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4484
Article PK: 246625


<Abhilash> wrote in message news:4f6a0339.5709.1681692777@sybase.com...
> Any idea about the error "1009134 Insufficient buffers for
> 'insert..select'."? In what scenario this can happen?
> I have 2GB cache configured for main & temp cache and 100GB
> temp dbspace. I am using Sybase IQ 15.3 in windows
> environment.
>
> Thanks in advance.

You might want to check with with TechSupport. One of the case says
"Reducing the setting for the Sort_Pinnable_Cache_Percent database option
for loads only seems to resolve the issue"
However changing Sort_Pinnable_Cache_Percent is not advisable unless it is
recommended by Sybase Tech Support

-HTH
Manish Negandhi
[TeamSybase]