Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Db2V10 Upgrade from V8

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
pkmurali
Warnings : 1

Active User


Joined: 15 Dec 2005
Posts: 237

PostPosted: Mon Jan 23, 2012 8:05 pm    Post subject: Db2V10 Upgrade from V8
Reply with quote

Hi All,

In my project, we are upgrading DB2V10 from V8. We found some difference like 'TIMESTAMP EXTERNAL' occupies X(26) in V8 and in X(19)v10. Also from google i got the following link
www-05.ibm.com/fr/events/db2.../DB2V10_Migration_Gareth_Jones.pdf

Where the Char data type has some incompatible changes,

Quote:

Incompatible changes
– CHAR() scalar function – solution for compatibility is coming
SQL scalar function CHAR() for COL1 DEC(4,0)
SELECT COL1
,CHAR(COL1)
,HEX(CHAR(COL1))
,SUBSTR(CHAR(COL1), 2, 4) APPL_SUBSTR
FROM DB2_TABLE;
+------------------------------------------------+ +-------------------------------------------------+
! COL1 ! CHAR_V9 ! HEX_CHAR_V9 ! APPL_SUBSTR ! ! COL1 ! CHAR_V10 ! HEX_CHAR_V10 ! APPL_SUBSTR !
+------------------------------------------------+ +-------------------------------------------------+
! 9 ! 0009, ! 40F0F0F0F96B ! 0009 ! ! 9 ! 9 ! F94040404040 ! !
! 99 ! 0099, ! 40F0F0F9F96B ! 0099 ! ! 99 ! 99 ! F9F940404040 ! 9 !
! 999 ! 0999, ! 40F0F9F9F96B ! 0999 ! ! 999 ! 999 ! F9F9F9404040 ! 99 !
! 9999 ! 9999, ! 40F9F9F9F96B ! 9999 ! ! 9999 ! 9999 ! F9F9F9F94040 ! 999 !
+------------------------------------------------+ +-------------------------------------------------+

But i can't find the difference of 'TIMESTAMP EXTERNAL' in that link. The 'TIMESTAMP EXTERNAL' detail is obtained from our DBA. Please let me know what are all the difference that need to be verified before upgrading V10.

Thanks,
Murali.
Back to top
View user's profile Send private message

gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Mon Jan 23, 2012 8:13 pm    Post subject:
Reply with quote

Correct link - http://www-05.ibm.com/fr/events/db2_zos/DB2V10_Migration_Gareth_Jones.pdf
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Mon Jan 23, 2012 8:15 pm    Post subject: Reply to: Db2V10 Upgrade from V8
Reply with quote

why not read about iy Yourself ...
starting from
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Mon Jan 23, 2012 8:19 pm    Post subject:
Reply with quote

From - DB2 10 for z/OS Technical Overview

With DB2 10 for z/OS new-function mode, timestamp data type can provide precision up to a
picosecond (10-12 of a second). You can control the number of digits for the fractional second
using the optional timestamp precision attribute. The precision attribute range is 0 to 12, and
the default value is 6 because only six digits for the fractional second were supported in prior
releases. Example6-25 illustrates various timestamp precisions that could be declared.
Example 6-25 Examples of timestamp precision

Code:
CREATE TABLE TRYTMSPREC(                                               
 ID INT                                                               
,TMS_DFLT TIMESTAMP                -- precision 6  (default )
,TMS_0    TIMESTAMP(0)             -- precision 0  (minimum supported)
,TMS_6    TIMESTAMP(6)             -- precision 6  (same as default)   
,TMS_9    TIMESTAMP(9)             -- precision 9                     
,TMS_12   TIMESTAMP(12)            -- precision 12 (maximum supported)
);



The external representation of a timestamp is a string representation of the form
yyyy-mm-dd-hh.mm.ss (19 bytes, when precision is 0) or yyyy-mm-dd-hh.mm.ss.nnnnnnnnnnnn
(where the number of digits n for the fractional second can vary from 1 to 12, resulting in
external length of 21 to 32 accordingly).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts CICS TS 5.3 migr after DFHCSDUP UPGRA... Kyle Carroll CICS 6 Wed Aug 31, 2016 10:58 pm
No new posts COBOL compiler upgrade vicky10001 COBOL Programming 4 Mon Jul 25, 2016 1:44 pm
No new posts Enterprise COBOL Upgrade from 4.2 to 5.2 enrico-sorichetti COBOL Programming 2 Fri Jan 08, 2016 11:45 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us