Best to let the IBM java apps reconfigure themselves by way of applying PTFs. Unless there's a documented procedure of course.
Steve Pitcher
iTech Solutions
Office: (203) 744-7854 Ext. 176
Mobile: (902) 301-0810
http://www.itechsol.com
http://www.iInTheCloud.com
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Justin Taylor
Sent: Saturday, May 5, 2018 9:44 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Java - 6
A few years ago on 7.1, i changed my system default from Java 6 to Java 7 and quite a few IBM things broke.
Like i said, that was several years ago, so YMMV.
________________________________________
From: broehmer@xxxxxxxxxxxxxxx [broehmer@xxxxxxxxxxxxxxx]
Sent: Friday, May 4, 2018 4:38 PM
To: Midrange Systems Technical Discussion
Subject: Java - 6
Have a question relating to Java on the system.
I'm at 7.1 and my (boss) wants to go ahead and remove Java 6 on our development box and see what happens.
We've got 7 & 8 on it and while I realize that when we move to 7.3 (next month) that won't matter but his question is what's going to happen to our system now?
How much "stuff" relies on 6 and why can't we just move to 7 or 8?
Bill Roehmer
Senior Pgmr/Analyst
The C.D. Hartnett Company
817 594-3813 ext. 1631
"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments accompanying it) contain confidential information belonging to the sender.
The information is intended only for the use of the intended recipient.
If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of the information is strictly prohibited. Any unauthorized interception of this transmission is illegal under the law.
If you have received this transmission in error, please promptly notify the sender by reply e-mail, and then destroy all coTVpies of the transmission."
From: Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 05/04/2018 01:06 PM
Subject: RE: Better SQL performance than SUBSTRING
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
That doesn't seem to work for me. The statement ran, but no object was created.
Here's my statement:
create index MY_TABLE_SUBSTRING on table MY_TABLE
(SUBSTRING(MY_COLUMN,5,6))
Here's the message iACS gave me on the create:
SQL State: 01505
Vendor Code: 143
Message: [SQL0143] Statement CREATE INDEX AUXILIARY TABLE ignored. Cause .
. . . . : Statement CREATE INDEX AUXILIARY TABLE is not supported by DB2
for IBM i. It has been ignored. Recovery . . . : No action is
required.
Statement ran successfully, with warnings (6 ms)
IBMi 7.3, PTF's current as-of 07 Apr 18
iACS 1.1.7.3
-----Original Message-----
From: Steve Needles [mailto:Stephen.Needles@xxxxxxxxxxx]
Sent: Friday, May 04, 2018 10:09 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Better SQL performance than SUBSTRING
Yes...you can create an index using a substring:
CREATE INDEX Table_Index
ON Table
(substr(Column,case when length(trim(Column))-7 <= 0
then 1
else length(trim(Column))-6 end , 7));
Generate a key using the last characters in the string no matter the total length of the string
Steve Needles
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
http://amzn.to/2dEadiD
"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments accompanying it) contain confidential information belonging to the sender. The information is intended only for the use of the intended recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of the information is strictly prohibited. Any unauthorized interception of this transmission is illegal under the law. If you have received this transmission in error, please promptly notify the sender by reply e-mail, and then destroy all copies of the transmission."
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
