Portal NW730 select correct Schema SAPSIDDB DB2 LINUX

[former_member802413]

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,

[Former Member]

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.

[former_member802413]

Dear All,

I did a test and found out the correct schema,

Created users from portal and checked the user table in both schemas , 

It was SAPNPPDB. SAPNPQDB had no updates, system used the first schema.

Thanks for help.

[martin_mikala]

Hi,

Was not this DB recovered from production portal?

B.R.

Martin