home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC83057 Status: Geschlossen

FEDERATION SERVER RECEIVED SQL0901N WHEN USING TRANSPARENT DDL WITHOUT
SPECIFYING REMOTE_SERVER OPTION

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
You may receive SQL0901N error when using transparent DDL 
without REMOTE_SERVER option. 
 
Reproducing scripts: 
 
CREATE TABLE T1(C1 INT) OPTIONS (REMOTE_SCHEMA 
'<your_remote_schema>', REMOTE_TABNAME 
'<your_remote_table_name>') 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "No remote 
server 
given".)  SQLSTATE=58004 
 
And here is the corresponding stack trace: 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x09000000006426BC pthread_kill + 0x88 
0x090000006094D878 sqloDumpEDU + 0x58 
0x09000000639711C4 sqldDumpContext__FP8sqeAgentiN42PCcPvT2 + 
0x144 
0x09000000620DB9C8 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x6A8 
0x0900000060B6D2F8 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x58 
0x0900000060B6DAF8 sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc + 
0x378 
0x090000006556FEEC sqlnn_erds__FiN41e + 0x1CC 
0x0900000068CF40DC 
sqlnq_create_trans_table_one__FP9sqlnq_qtbP11option_pairP3loc + 
0xA7C 
0x0900000068CF574C 
sqlnq_sem_djx_tran__FPP8stknode_i10actiontypePUcP3loc + 0x1AC 
0x09000000677BA748 sqlnp_smactn__FP8sqlnp_cbi + 0xB28 
0x09000000677C5994 sqlnp_parser__FP8sqlnp_cb + 0x1994 
0x09000000677B867C sqlnp_main__FP12sqlnq_stringsPP9sqlnq_qur + 
0xABC 
0x090000006565C134 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_enviT7PP9sqlnq_qur + 0x41F4 
0x09000000656611E4 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_env + 0x64 
0x09000000625B9548 
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P16sqlra 
_cached_varPiPUl + 0x1728 
0x09000000623D0198 
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi 
T4PUcT4UsUcP14sqlra_cmpl_enviPiT11_T12_N311_T12_P14SQLP_LOCK_INF 
OPP16sqlra_cached_varT12_PUlb + 0xD98 
... ...
Problem-Zusammenfassung:
User affected: 
  Users in InfoSphere Federation Server 
Problem description and summay: 
  See error description
Local-Fix:
Specify the REMOTE_SERVER option.
Lösung
Problem was fistly fixed in Version 9.5, FixPak 10. This 
fix should be applied on the federation Server.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.05.2012
01.11.2012
01.11.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.
Problem behoben lt. FixList in der Version
9.5.0.10 FixList