db2admin@dm2x:~> db2 connect to GPGL user db2admin using password

Database Connection Information

Database server = DB2/LINUXX8664 10.5.1
SQL authorization ID = DB2ADMIN
Local database alias = GPGL

db2admin@dm2x:~> db2 -tf /opt/ibm/db2/V10.5/misc/EXPLAIN.DDL

******* IMPORTANT **********

USAGE: db2 -tf EXPLAIN.DDL

******* IMPORTANT **********


DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

db2admin@dm2x:~>

DBA3065E Снимок нельзя обработать из-за ошибки CLI.

Объяснение:

При обработке снимка произошла ошибка CLI. План доступа вывести нельзя.

Действия пользователя:

Проверьте конфигурацию CLI, введя следующую команду:

db2 get cli cfg
for section <имя-базы-данных>

Если значение LONGDATACOMPAT равно 1, попытайтесь внести базу данных в
каталог с другим алиасом:

catalog db <имя-базы-данных> as <алиас-базы-данных>

Задайте для алиаса базы данных LONGDATACOMPAT=0:

db2 update cli cfg for section <алиас-базы-данных> using
longdatacompat 0

Передайте запрос для EXPLAIN в базе данных алиаса.

Если значение LONGDATACOMPAT не равно 1 или если этот параметр не задан
в конфигурации CLI, обратитесь в центр IBM по обслуживанию.