MQSeries.net :: View topic - Neon format Imports

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Neon format Imports

Neon format Imports

« View previous topic :: View next topic »

Author

Message

smdavies99

Posted: Mon Nov 10, 2003 2:31 am Post subject: Neon format Imports

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Does any reader know of a sure fire way to verify that a format import has succeeded.
We had an instance recently (WMQI2.1) where according to the output of NNFIE reported the import was successful but the change was not in the database.
I tried looking at the various Database Tables and the number of rows in each table before and after an import(forced) but there was no difference.
There are some table with incrementing sequence counts but I am not sure of the relevance of them before/after an import.
I did suggest doing an export and the comparing the results but the time to do this would extend the whole process beyond what is feasible and acceptable to the customer.

Stephen D
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

vmcgloin

Posted: Mon Nov 10, 2003 4:56 am Post subject:

Knight

Joined: 04 Apr 2002
Posts: 560
Location: Scotland

Quote:

We had an instance recently (WMQI2.1) where according to the output of NNFIE reported the import was successful but the change was not in the database.

If this is the case then you should be reporting it as a problem to IBM.
Sorry for not answering your question, but the best thing would be to determine why this failed....

smdavies99

Posted: Tue Nov 11, 2003 5:01 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

We already have a PMR (sev 3) opened on this but It has only happens once in a blue moon. This in not a high priority. There are other more important PMR's that need fixing before this one such a broker abend.

So, living in the real world and after some investigation I have come up with the following.

select grant_id,dt_tm_chg from NN_PERMISSION_LIST where grant_id=(select max(grant_id) from NN_PERMISSION_LIST);

select grant_id,dt_tm_chg from NN_CMPNT_GRANT where grant_id=(select max(grant_id) from NN_CMPNT_GRANT);

will show an updated grant_id whenever a format is imported. We are going to put this into the batch scripts that are used to do the bulk imports. The output wil be putinto the same log files as the nnfie output. Then if one fails to update the DB then the log should show which one it is.

Stephen D
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Neon format Imports

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP