Share 'Executing packages get SQL0525N error after nickname drop and recreate'
The content here is verified on DB2 v97fixpack 0.
There are a number of changes (such as adding new columns) in the datasource tables. As a result, we must drop and recreate the nicknames for any tables included in the changes. Hence all of our dependent packages are getting set to VALID=NO resulting in -525 errors at execution time.
SQL0525N The SQL statement cannot be exec…
You can share this blog post in two ways…
Share this link:
Send it with your computer's email program: Email this