Skip to Content
author's profile photo Former Member
Former Member

Portal NW730 select correct Schema SAPSIDDB DB2 LINUX

Dear All,

I need to export a Portal system NPQ. Which schema should I export

1 ) Which Schema is my Current portal system ( NPQ) using. When I execute the statement below, I get two answers, the two contender are ofcourse SAPNPPDB and SAPNPQDB. Surprisingly there are two schema - may be due to old system copy.

In the Config tool -> Secure store -> Connection Pool -> NPQ properties URL has Schema=SAPNPPDB and user = sapnppdb

So , I am confused to export SAPNPQDB or SAPNPPDB because SID is NPQ and in configtool connection is related to NPP.

*************

db2 => select schemaname from syscat.schemata

SCHEMANAME

--------------------------------------------------------------------------------------------------------------------------------

NULLID

NULLIDR1

NULLIDRA

SAPNPPDB

SAPNPQDB

SAPTOOLS

SQLJ

SYSCAT

SYSFUN

SYSIBM

SYSIBMADM

SYSIBMINTERNAL

SYSIBMTS

SYSPROC

SYSPUBLIC

SYSSTAT

SYSTOOLS

******************************************************************************************************

Please help me choose which schema should I choose in the export step DATABASE Schema . SAPNPQDB or SAPNPPDB ?

Regards,

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2016 at 07:05 AM

    Hi Nick,

    SAPNPQDB is the correct schema for NPQ.

    May be the post system copy steps were not performed when NPQ system was refreshed with NPP database.

    For export/import guide refer below link

    https://websmp110.sap-ag.de/~sapidb/011000358700001324482012E

    Regards,

    Prithviraj.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.