database utility

[Former Member]

Hi all,

Here i have changed the lenght of field in the table pa9103.

custom field only .

i try to activate but it is giving some errors

then i went to se14 and try to adjust the table but the system is saying error in step 2.

can any body help me in this regards we are using ECC 6 .

with regards

anand

[Former Member]

Hi Anand,

Can you tell what is the error?

Regards,

Atish

[Former Member]

Request: Convert Table PA9103 (ANANDK/22.10.07/17:14)

Process: cisdev_1

Enhancement category 3 possible, but include or subty. not yet classified

Test activation of Table PA9103 successful

Field PERF_GRADE: Type change

ALTER TABLE is not possible

Database object for table PA9103 is checked

Database object for table PA9103 is consistent

Convert Table PA9103 by unloading and reloading the data

Type of conversion: T -> T

Begin step PA9103-STEP1:

Step is empty

Step PA9103-STEP1 executed successfully

Begin step PA9103-STEP2:

sql:

RENAME TABLE "PA9103" to "QCMPA9103"

SQL0289N Unable to allocate new pages in table space "SYSCATSPACE".

SQLSTATE=57011

DDL time(___1): .......606 milliseconds

The SQL statement was not executed

Renaming of table PA9103 to QCMPA9103 failed

Error in step PA9103-STEP2

Total time for table PA9103: 000:00:01

Request for PA9103 could not be executed

Request: Convert Table PA9103 (ANANDK/22.10.07/17:15)

Process: cisdev_1

Enhancement category 3 possible, but include or subty. not yet classified

Test activation of Table PA9103 successful

A restart log already exists for table PA9103

[Former Member]

Hi,

I guess you'll have to check with your BASIS people

<i>Begin step PA9103-STEP2:

sql:

RENAME TABLE "PA9103" to "QCMPA9103"

SQL0289N <b>Unable to allocate new pages in table space "SYSCATSPACE".</b>

SQLSTATE=57011

DDL time(___1): .......606 milliseconds

The SQL statement was not executed

Renaming of table PA9103 to QCMPA9103 failed

Error in step PA9103-STEP2</i>

The problem has more to do with system rather than the procedure you are following.

Hope this helps

Regards

Nishant

null

[Former Member]

Hi Anand ,

From the ECC systems whenever you create a table you need to do One more step so that later on stages based on that step only it will accept your change's (or ) Restrict not to do that changes .

And i am sure that your table has <b>Option 5</b> .that is why it was giving Error.

Step is se11->open your table in the Menu Extras->Enhancement Category (CLICK on it )

see the Options and Observer Which option it was Opted for your table

<b>1.Cannot be enhanced

2.Can be enhanced or character type

3.Can be enhanced or character-type or numeric

4.Can be enhanced in any way

5.Not classified</b>

This category can be chosen, for example, for a transition status; however, it must not be chosen for creating structures.

so Opted for the 3 one .

Reward points if it is usefull ...

Girish