Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-12-11T06:55:57Z by zhaoguob
SystemAdmin
SystemAdmin
1632 Posts
ACCEPTED ANSWER

Pinned topic bogus -551 errors in DS 3.1.1 guided tuning set up

‏2012-12-06T16:00:37Z |
I'm told during the guided tuning set up that I don't have privs on an XML table (we don't use XML so why should I care?), but SPUFI proves I do. What gives?

See attached
SET CURRENT SQLID = 'HESSAM';
---------+---------+---------+---------+---------+---------+--
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+--

SELECT COUNT(*) FROM SYSIBM.SYSXMLRELS;
---------+---------+---------+---------+---------+---------+--

---------+---------+---------+---------+---------+---------+--
6
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
Updated on 2012-12-11T06:55:57Z at 2012-12-11T06:55:57Z by zhaoguob
  • zhaoguob
    zhaoguob
    32 Posts
    ACCEPTED ANSWER

    Re: bogus -551 errors in DS 3.1.1 guided tuning set up

    ‏2012-12-11T06:55:57Z  in response to SystemAdmin
    Thanks for reporting the problem. It seems a strange one, could you help to collect the following trace and add as an attachment? then we will look into further.
    1. Open OQT and click "Window" -> "Preferences", find "Query Tuner" preference page, click "Enable Query Tuner trace" and "Clear Trace", then click "OK".
    2. Then use OQT to recreate the problem
    3. Open the directory which shown in the preference page, sort the files by "Date Modified" to find the latest trace file, then send the file to us (It is better to compress the file in zip format).