Discussion:
Delta table name
(too old to reply)
Max Bakken
2017-04-28 09:09:05 UTC
Permalink
Hi,
I have been having issues with my delta engine and we desided to try and update the TDI 7.1.1. installation from fp4 to fp6.

Upgrade of the fixpack worked without a problem, but started to get strange errors in the delta engine.

It no longer found the delta stores that was defined in my assemblylines.

After some testing we found out that you can now write table name in lowercase.
It is added to the derby (server store) with the case you write it in.

Meaning if you have a store called myStore, prior to this version it would have been IDI_DS_MYSTORE, now it has been changed to IDI_DS_myStore.

Problem 1: Older assemblylines with delta names that contains lowercase do no longer work.
Workaround for this is to change the name of the delta tables everywhere to uppercase and thing will work again.

Problem 2: Cannot delete delta.
You cannot goto the server store and select a delta and delete the table data.

Is there a reqason why this "feature" has been added?

-Max
Arnstein Kjellevold
2017-05-09 11:46:26 UTC
Permalink
Hi,

I have the same problem.

Delta tables used to be created all UPPERCASE regardless of case used in the AL.
Now with recent patch levels Deltas are being created with mixed case and expecting to find mixed case tables for existing deltas. This then breaks existing ALs since they fail to find the already created (all uppercase) delta table.

Is this change documented somewhere? Is it possibly related to IO23879?

Also, like Max stated, its not possible to delete tables created with mixed case so this change does not seem to be fully implemented yet.

Arnstein
Jason Williams
2017-05-09 18:00:11 UTC
Permalink
Post by Arnstein Kjellevold
Hi,
I have the same problem.
Delta tables used to be created all UPPERCASE regardless of case used in the AL.
Now with recent patch levels Deltas are being created with mixed case and expecting to find mixed case tables for existing deltas. This then breaks existing ALs since they fail to find the already created (all uppercase) delta table.
Is this change documented somewhere? Is it possibly related to IO23879?
Also, like Max stated, its not possible to delete tables created with mixed case so this change does not seem to be fully implemented yet.
Arnstein
I believe the APAR you're looking for is APAR IO25103
http://www-01.ibm.com/support/docview.wss?uid=swg1IO25103

The link indicates this will be made available in TDI 7.1.1.7. If you need the jar before then, please contact IBM Support to obtain the patched jar.
Loading...