When a non-clustered index is created in ase15, the data buffer memory is insufficient.

---------------------------------------------------------------------------

---- This is andkylee's personal originality. Please repost it with respect to the author's Labor achievements;

---- The original source must be specified for reprinting.
:
Http://blog.csdn.net/andkylee

---



2010-07-13
17:43:27

---- Keyword: nonclustered index default data cache insufficient 1526

Insufficient data cache non-clustered Index

----------------------------------------------------------------------------

This afternoon, when creating non-clustered indexes in batches on the solaris10 ase15.0.3 platform, the following error is reported:

MSG 1526, Level 17, state 5:
Server 'syb _ nfjd_test ', procedure 'SP _ helpdb', line 674:
Sort failure. The configure size for data cache (default data cache) is not
Sufficient to handle the sort buffers (128) requested. Please reconfigure
Data cache or sort buffers and try the command again.
(Return status =-7)

 

Run the command sp_helpcache "default data cache" to find that the high-speed data buffer size is 8 MB, which is the default value.

Run the following command to expand the default data cache to 100 m, sp_cacheconfig "default data cache", "100 m"

Then, re-execute the non-clustered index creation process!

 

The error message & troubleshooting does not find the error 1526 explanation and solution.

At present, I have not figured out why the default data cache is required when creating a non-clustered index, and the default data cache is insufficient. Does the default data cache need to cache the index page data at a certain level?

 

 

Bytes ------------------------------------------------------------------------------------------------

The following is an online search related to error: 1526.

The failure is most likely happening on the remote server where
Actual
Physical table lives. It's certainly possible to create
Indexes on proxy
Tables, But what really happens is that
Physical Index is created on
Remote Server. Try logging in
The remote server where the actual table
Resides. Check the memory
Settings on the remote server.

> Hi,
> I am
Trying to create a non clustered index on an "existing
>
Table "(proxy table). But it keeps failing with the error,
>
>
Sort failure. The configure size for data cache (default
> Data
Cache) is not
> Sufficient to handle the sort buffers (30008)
Requested.
> Please reconfigure
> Data cache or sort
Buffers and try the command again.
>
> The data cache is
Configured 2 gig, 800 mb for 8 K pool
> I have this configuration
Enough for most of the things.
>
> How can I make the non
Clustered index.

 

Summary:

When a non-clustered index is created, the use of the default data cache is involved. Whether you create a non-clustered index on a basic table or a proxy table, data cache is used on the ASE server where the physical table is located. If the data cache is insufficient, a 1526 error message is returned. The solution is to add the default data cache to sp_cacheconfig.