Hello Princesmay,
it depends on what will be in the .ixf files ... if there are just values and constraints it should not be a problem ... the problem can come with triggers and such ...
Parnamwulan
Last Activity: May 7 '10, 08:12 AM
Joined: Apr 8 '08
Location: Brno, CZ
-
Parnamwulan replied to i am getting error of SQL0811N in db2 stored procedure. please help its urgent!!!in DB2Hello Mohit,
you can do SELECT INTO only if the result returned is one value ... you have more values returned thats why the error SQL0811N
If I would be you I will define the unique key on the deal_id column to be sure only one value is returned.Leave a comment:
-
Hello chandb,
the bufferpool is how database is defined to handle memory
- you have a table
- this table resides on some tablespace
- the tablespace needs to have container to handle space
- the tablespace needs to have bufferpool to handle memory
- the bufferpool is assigned to tablespace and contains of number of pages and pagesize
If you expect the table will be small...Leave a comment:
-
Hello Amijai,
you dont have properly set the terminator for the statement ...
you can run it with
db2 -td terminator
and put the terminator after each section which needs to be run before continuing ...Leave a comment:
-
Hello Princesmay,
you need to have the same codepage on both dbs
you can change the codepage by:
db2set db2codepage=
or you can specify MODIFIED BY CODEPAGE option ... but it will not work for .ixf files as they have inside the source codepageLeave a comment:
-
Hello,
I have good experience with XOR encoding - its quite easy to use and secureLeave a comment:
-
Dynamic SQL solved the pb ...Leave a comment:
-
Hello,
You are limited only with the destination disk space (device space) up to 2TB (as docdiesel said) ... and optionally by bufferpool assigned (operating memory - you cannot load e.g. 2TB table in one piece)
you can setup the pagesize up to 64k (depends on system) and then count your available space divided by 65536 (I hope - my system dont support it) or the highest available for your system (1k = 1024)Leave a comment:
-
You can create new instance with db2ictl command or alter the system variable with
Set DB2INSTANCE with
<code>Set DB2INSTANCE=DB2 </code> ( valid for linux)
there is no DB2 command for it since the instance works (in fact) on higher lvl than the databaseLeave a comment:
-
Hello,
It depends .... if you would like the table to be read-only for some user, you can create a group with only SELECT priviledges (NO DELETE, DROP or UPDATE or INSERT - just SELECT ONLY)
then, if you will add the user to that group he will not be able to modify anything anywhere ...
or you can create a view for him with select only priviledge .... there is no possibility to restrict the editing of...Leave a comment:
-
The create table statement itself has almost no overhead - there cannot be simply said if it is better to have one big table or three small - it depends on what you would like to do with the data ... if you will expect a lot of operations dedicated to columns, then it will be better to create more tables with less column count and then you can e.g. propagate it to users as "view"Leave a comment:
-
For select statements it will have quite normal performance as have selecting from standard tables
For insert - it depends on the method and task - if there will be the possibility to count the column, it will be the best
If not, then it depends on what you need to store in the table - if you would like to add a column to the table with existing data, do not use the import/insert update command because it will take serious time...Leave a comment:
-
CHAR to DATE conversion
Hello,
I imported the file with date values .... since I dont know any possibility how to import value like '20080429' as date directly I imported the column as char and now I would like to setup trigger or counted column which will convert the char to date for me.
I wrote the trigger:
...Code:CREATE TRIGGER SCANTIME AFTER INSERT ON xxx.ASSET_REPORT FOR EACH ROW UPDATE xxx.ASSET_REPORT BEGIN
-
SQLDA problem - data type doesnt match
Hello guys,
Pls dont laugh - it is not funny (actually it is, but it is causing me problems)
I have problem with SQLDA data type specification.
I need to create some counted columns, so I decided to write a trigger (or set of triggers - we will see) to count for me automatically.
I added the column where I would like to have results using command:
db2 "ALTER TABLE <table>... -
It is solved ... I was importing (using import command) with "insert into" statement and I had bad informations about the data format
The IMPORT command with "create into" statement solved the problemLeave a comment:
-
DROP system stored procedure restriction
Hello everybody,
I am running DB2 on linux ....
I need to import a huge table to the database I created and I found out that I have not enough BLOB size (I hope I have 320k - it should be default) ... the table is stored in .ixf format (the source db is on mainframe) and it has 180 columns.
The error I got and the explanation how to correct it is here: http://publib.boulder.ibm.com/infocenter/cmgmt/v8...
No activity results to display
Leave a comment: