Symptom
Following a System copy during transaction STMS/SE06, a short dump is received.
Short dump error
SQL30082N Security processing failed with reason "24"("USERNAME AND/OR PASSWORD INVALID").
Developer trace file shows the full error.
SQL0150N The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted. SQLSTATE=42807
This Sqlcode does not necessarily indicate a problem if the affected table is a virtual table.
Table <tablname> is a virtual table for deferred table creation.
Virtual table <tabnname> needs to be converted to a table.
Opening temporary connection for deferred table creation of table <tabname>
Error: SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
Read more...
Environment
Db2 LUW IBM
Keywords
system copy, backup restore, Virtual, Materialise, DBSQL_SQL , KBA , BC-DB-DB6-SYS , Database Interface/DBMS , Problem
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.