SAP Knowledge Base Article - Preview

2203873 - Error 326 when using ALTER TABLE to split a partition - SAP ASE.

Symptom

Error 325 when using ALTER TABLE to split a partition

Example:

alter table xxx_xxx_xxx_xxx partition pM20140201 into (
pD20160102 VALUES <(><<)>= ("D", "01/02/2016"),
pM20140201 VALUES <(><<)>= ("M", "02/01/2014")
)

Number (326) Severity (16) State (1) Server (XXXXXXX) ALTER TABLE 'xxx_xxx_xxx_xxx_info' failed. The table is 0-way partitioned, and a 1-way parallel plan was generated due to lack of parallel resources. Increase the value of 'max parallel degree' and 'number of worker processes' to at least 0, and try again.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • Compatibility mode is on

Product

SAP Adaptive Server Enterprise 15.7

Keywords

326, error, message, msg, PARTITION, ALTER TABLE, SPLIT, compatibility mode , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.