Post SAP DB2 Refresh

5 pts.
Tags:
DB2
SAP
SQL
SAP Post refresh DB2, we get this dump always for every T code when ever it hits new Virtual table:
Database error text: "SQL message: DbSlModifyDB6: Virtual table ASPART_CONF is not owned by current connect user."
I hit the transfer owner command and it is resolved but again new issue arises with other table Is there a way where we can change ownership of all virtual tables in single shot. Help would be obliged


Software/Hardware used:
SAP,DB2
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Michael Tidmarsh
    Hi FAYZAN! Here's a response from one of our experts ToddN2000:

    You might want to try something like this.

    db2 -x "select 'db2 transfer ownership of view SAPNEP.' || chr(34) || viewname || chr(34) ||
                   ' to user SAPNEQ PRESERVE PRIVILEGES'
             from syscat.views where TYPE ='V' and OWNER <> 'SAPNEP' "

    65,700 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: