RE: ODBC problem (I think)

Good Idea, I checked and there are no program registerd


Denis Robitaille
Chef de service TI – Solution d’entreprise
Infrastructure et opérations

CASCADES CENTRE DES TECHNOLOGIES
412 Marie Victorin
Kingsey falls(Québec) Canada J0A 1B0
Tél : 819 363 6100 Poste :52130
Cell : 819 352 9362


-----Message d'origine-----
De : MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> De la part de Gary Monnier
Envoyé : 13 juillet 2018 11:35
À : Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Objet : Re: ODBC problem (I think)

Do you have an exit program on the ODBC-related exit points?

ODBC Exit points:
QIBM_QZDA_INIT called at server initiationQIBM_QZDA_NDB1 called for native database requestsQIBM_QZDA_SQL1 called for SQL requestsQIBM_QZDA_SQL2 called for SQL requestsQIBM_QZDA_ROI1 called for retrieving object information requests and SQL catalog functions



Gary Monnier
*ATI Administrator*
*425.427.7959*

On Fri, Jul 13, 2018 at 8:24 AM, Denis Robitaille < denis_robitaille@xxxxxxxxxxxx> wrote:

Hello,

I checked that audit journal. I fount GR, JS and ZC transactions.
Nothing unsual in them

The QZDASOINIT joblog did not show anything special either.

And just to let you know, the user I used has *ALLOBJ *SECADM
*IOSYSCFG *JOBCTL *SAVSYS *SECADM *SERVICE *SPLCTL special authority.
So it should have access to everything.

-----Message d'origine-----
De : MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> De la part de Bryan
Dietz Envoyé : 13 juillet 2018 10:52 À : Midrange Systems Technical
Discussion <midrange-l@xxxxxxxxxxxx> Objet : Re: ODBC problem (I
think)

have you checked the audit journal to see if there is anything else
that the user might not be authorized to?

were you able to find the joblog of the QZDASOINIT job to see if
anything in there was interesting?

Bryan



Denis Robitaille wrote on 7/13/2018 9:37 AM:

Hello all,

I am faced with a situation that I can not understand.

We have an excel spreadsheet that do a qwery on an Iseries. With
some

users it works fine, with other we get the following error:

[IBM][ODBC System i Access Driver][DB2 for i5/OS]SQL0551 - Not
authorized to object QZDA07600X in QGPL, type *SQLPKG]

With my user, it works fine so I cloned it. With the clone, I still
get

the error. The clone as *ALLOBJ but still gets the error.

I even deleted the QZDA07600X SKLPKG since it would get recreated
by

the system if necessary. I still get the error even if the object do
not exist!!!!

I am out of idea.

Here is what I think are the key information:
We are at 7.2

Here is the connection string:
DRIVER={iSeries Access ODBC driver}; XDYNAMIC=0;
PKG=QGPL/DEFAULT(IBM),2,0,1,0,512;
LANGUAGEID=ENU;DFTPKGLIB=QGPL;DBQ=QGPL CDTAWHSE;
SYSTEM=cas800re.cascades.com;

The query is a simple SELECT from a single file

Any help would be appreciated

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.
midrange.com_mailman_listinfo_midrange-2Dl&d=DwIGaQ&c=
pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_ztz5b0wbCtdhwrG0PzYq8&m
=
IZErN92WNgnaOdLlLAkjFW4ZBEINyb5VpdtaTlqoR8s&s=gkFEoJguT-
bB8JJFwKGzLJbR4IGWhirw3P5jDpJ6_EY&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__
archive.midrange.com_midrange-2Dl&d=DwIGaQ&c=pApUd0AUA6FmKRo01iR_VA&r=
r7w16KGEqE6t2tVCvCsz4_ztz5b0wbCtdhwrG0PzYq8&m=
IZErN92WNgnaOdLlLAkjFW4ZBEINyb5VpdtaTlqoR8s&s=
NiJhgcDah7TcUT673PWccsuJgs3Yufm0TXEgUhnxrdc&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_
2dEadiD&d=DwIGaQ&c=pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_
ztz5b0wbCtdhwrG0PzYq8&m=IZErN92WNgnaOdLlLAkjFW4ZBEINyb5VpdtaTlqoR8s&s=
4qf3r42GFLES4N_d_cDtmy24BD75_Kdu7J0jfskBSeY&e=

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD