Getting error SQL8029N when loading from cursor.

Troubleshooting

Problem

When trying to load from cursor SQL8029N license error is seen. "load from c1 of cursor messages msg.out insert into TEST_TABLE nonrecoverable" SQL8029N A valid license key was not found for the requested function. The current license key for this product does not allow the requested functionality. Purchase the license key for this function from your IBM representative or authorized dealer and update your license using the License Center or the db2licm command line utility.

Symptom

Test case:

/home/db2inst1$ db2 connect to sample

Database Connection Information
Database server = DB2/AIX64 9.7.8
SQL authorization ID = DB2INST1
Local database alias = SAMPLE

/home/db2inst1$ db2 "create table db2inst1.test3(col1 integer)"
DB20000I The SQL command completed successfully.
/home/db2inst1$ db2 "insert into db2inst1.test3 values(1),(2)"
DB20000I The SQL command completed successfully.
/home/db2inst1$ db2 "select * from db2inst1.test3"

COL1
-----------
1
2
2 record(s) selected.

/home/db2inst1$ db2 connect reset
DB20000I The SQL command completed successfully.
/home/db2inst1$ db2 connect to sampleb

Database Connection Information
Database server = DB2/AIX64 9.7.8
SQL authorization ID = DB2INST1
Local database alias = SAMPLEB

/home/db2inst1$ db2 "create table db2inst1.test3(col1 integer)"
DB20000I The SQL command completed successfully.
/home/db2inst1$ db2 "declare c1 cursor database sample user testid using password for select * from db2inst1.test3"
DB20000I The SQL command completed successfully.
/home/db2inst1$ db2 "load from c1 of cursor messages msg_20140404.out insert into db2inst1.test3 nonrecoverable"
SQL8029N A valid license key was not found for the requested function. The current license key for this product does not allow the requested functionality. Purchase the license key for this function from your IBM representative or authorized dealer and update your license using the License
Center or the db2licm command line utility

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Routines (SP \u0026 UDF) - SQL","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;10.1;10.5","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

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 the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

link to actual document

Was this topic helpful?

Document Information

More support for:
Db2 for Linux, UNIX and Windows

Software version:
9.8, 9.7, 9.5, 10.1, 10.5

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
510025

Modified date:
01 May 2025

UID

swg21673146

IBM Support

Tips