Добрый день, уважаемые пользователи.
С некоторых пор (подозреваю, что после установки InfoSphere DataStage в систему), не получается некоторому прикладному ПО (как например DbVisualizer, InfoSphere Change Data Capture, Cognos) получить список таблиц. Взамен выводится сообщение
Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-727".
При этом ControlCenter чувствует себя прекрасно. Список таблиц получает.
Поиск по этой ошибке в интернете, выявил две возможные причины:
1. необходимость байндов
1.
2.
db2 BIND C:\bnd\@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
db2 BIND C:\bnd\@db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
db2 BIND C:\bnd\db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE
Это выполнено было и не принесло видимых результатов.
Результат выполнения этого скрипта:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
C:\bnd>db2 BIND C:\bnd\@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
LINE MESSAGES FOR db2ubind.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
LINE MESSAGES FOR db2ajgrt.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLABF01" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2ueiwi.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUAF16" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2uigsi.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUCF05" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2ucktb.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUJF05" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2uiici.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUDF01" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2uiict.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUEF00" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2uexpm.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUBF04" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2uimpm.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUFF10" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2uImpInsUpdate.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUPF00" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2ugtpi.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUHF01" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2pctsp.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLP1F01" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2uredp.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUIF00" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2urexp.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUGF00" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2clpcs.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLC2F0A" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2clprr.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLC3F09" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2clpur.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLC4F09" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2clprs.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLC5F09" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2clpnc.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLC6F09" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2arxcs.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLA1F00" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2arxrr.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLA2F00" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2arxrs.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLA4F00" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2arxnc.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLA5F00" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2arxur.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLA3F00" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2dropv.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLE3F01" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2uimtb.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUKF09" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2uqtpd.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUMF00" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2uqtnm.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLULF00" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2ulxld.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUNF01" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2uiXmlparse.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUZF00" already exists. SQLSTATE= 42710
LINE MESSAGES FOR db2uipkg.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "DB2ADMIN". Package
"NULLID.SQLUOF00" already exists. SQLSTATE= 42710
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "32" errors and "0"
warnings.
C:\bnd>db2 BIND C:\bnd\@db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
LINE MESSAGES FOR db2cli.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0091N Binding was ended with "0" errors and "0" warnings.
C:\bnd>db2 BIND C:\bnd\db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE
LINE MESSAGES FOR db2schema.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
2445 SQL0440N No authorized routine named "RTRIM" of type
"FUNCTION" having compatible arguments was found.
SQLSTATE= 42884
SQL0091N Binding was ended with "0" errors and "1" warnings.
2. Проблемы с доступом к схеме SYSIBM у активного пользователя (db2admin).
db2admin включен в группу db2admns в Windows, никаких особых действий над ним не совершалось.
После попытки установить второй экземпляр db2, ситуация повторилась: список таблиц не получается.
Прямой запрос
select * from sysibm.tables
нормально отрабатывает.
ОС: Windows 2003,
DB2 Express-C v9.5
В чем может быть проблема и как ее можно решить?
