Ask a Question related to IBM DB2, Design and Development.
-
Tilmann #1
ASCII and EBCDIC Tablespaces and performance on z/OS
We have to maintain the same collating sequence between an oracle
database on NT and a db2 on z/OS. FOr this, we are planning to use an
ascii tablespace for the data on z/OS. The main processing of the data
is via huge batch jobs on z/OS, which are reading the data as ebcdic
data, a minor part is processing via db2 connect on NT as ascii data.
Is there any performance hit if we are using ascii tablespaces
compared to the use of ebcdic tablespaces?
Thanx
Tilmann Guest
-
is this whole file EBCDIC?
is this whole file EBCDIC? Or just the text part.? Thanks Record length is 114 Field between columns 10 and 14 is a packed-decimal number... -
check whether file is ascii or ebcdic
Hi How do I check whether a file is in ebcdic or ascii format ? Thanks, Nitish -
#25499 [Fbk->Opn]: select * from tabname returns ebcdic data
ID: 25499 User updated by: mike dot mcsherry at ociofc dot usda dot gov Reported By: mike dot mcsherry at ociofc dot usda dot... -
#25499 [Opn->Fbk]: select * from tabname returns ebcdic data
ID: 25499 Updated by: sniper@php.net Reported By: mike dot mcsherry at ociofc dot usda dot gov -Status: Open... -
tablespaces for LOB data
does anyone know why do we need to use a bufferpool clause in the 'create long tablespace' statement? lob data is not cached anyway...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
