IBM Support

Db2 v9.7: SQL0750N encountered when performing a table rename with existing index

Troubleshooting


Problem

After upgrade database from v9.5 to v9.7, it's not possible to rename table where index exists while table created in v9.7 could be renamed. A rename fails with SQL0750N.

Symptom



This is a scenario that causes the issue:

create database testdb;
                                                   
connect to testdb;    
                                                   
create table t1 (ID INTEGER, DESC VARGRAPHIC(100) NOT NULL, DESCU VARGRAPHIC(100) NOT NULL GENERATED ALWAYS AS (UCASE(DESC)) PRIMARY KEY);

rename t1 to t2;
--command above will generate SQL0750N under v9.5 and will not generate error under v9.7

connect reset;    
             
--under v9.5
backup database testdb;

--under v9.7
restore database testdb;  
                                         
rename t1 to t2;
--command above will generate SQL0750N for v9.5 upgraded to v9.7

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Tables","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21445314

Page Feedback