RE: OmniFind product question

["Needles,Stephen J" <SNEEDLES@xxxxxxxxxxxxx>]

Nicholas,

1. According to the system admin folks...we are current with our PTFs having loaded the most recent cume tape.

2. You are correct...this product required a number of changes to my user profile (including changing the CCSID from 65535 to 37) to allow access to those system catalogs.  I worked with our SECOFR to resolve those and I am no longer on his list as a violator of security.

In the end, I think that you are right and I will have to call IBM.

steve

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Nicholas T Lawrence
Sent: Friday, September 10, 2010 5:13 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: OmniFind product question



Steve,

This might be an issue that needs some support involvement, but can you
check a few simple things.

1) Are all current 5733-OMF PTFs and the latest Database fix pack PTFs on
the system?
     I know that there have been a few problems that sound similar to this
one that have been fixed in the past.

     Because of the product's heavy dependence on database and the
operating system support, PTFs for both products may be necessary to get
the latest fixes.

2) Does the user profile attempting the create have enough authority to the
library?  It is possible that the product does not have enough authority to
retrieve information about the schema, and that causes it to believe that
the schema does not exist.

The OmniFind stored procedures in general require a high level of authority
to several system catalogs, as well as the authority to create the
necessary objects in the target schema.