New answers tagged db2
1
You cannot restore a DB2 database from AIX into Windows because of the endian. These are not compatible architectures.
For more information, check the InfoCenter: http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.admin.ha.doc/doc/c0005960.html
The only way to retrieve the data between these platforms is via db2look + db2move.
...
3
Unfortunately, it's not possible to take an online backup of a DB2 database if it's in circular logging mode, which is the default for DB2 databases when they are created.
You can check whether your database is using circular logging by issuing:
./db2 get db cfg for dbemp | grep LOGARCH
If both LOGARCHMETH options are switched off...
First log archive ...
2
Online backups require that the database be enabled for rollforward recovery. However, this is not the default when you create a database.
In order to do this, you need to set the LOGARCHMETH1 database configuration parameter. Once you have done this, you'll need to take one offline backup (i.e., no users can be connected).
Once you've completed these ...
0
Are you sure you have only one table? I mean, it seems that you create a table TEST_TBL without schema (taking current/default schema), and you are accessing USERID.TEST_TBL. Probably, the current schema for TEST_TBL is not USERID, and you already have a second table with tha name (USERID.TEST_TBL) that is empty.
For declared temporary tables, the schema is ...
4
By default the global temporary tables are created with the option ON COMMIT DELETE ROWS. Whatever tool you are using to run your statements must have the autocommit option turned on, so as soon as you issue the INSERT statement it is committed, thus deleting rows in the table.
You should either create the table using the ON COMMIT PRESERVE ROWS option, or ...
0
Ahh....That has to do with profiles. Root was not set up by default to have DB2 libraries set up in its profile, so it doesn't recognize the DB2 executables. This is not to say root can't do what you are asking, you would just have to browse to the /instance/bin folder to find the executables you are after. Of course, then you have to worry about whether or ...
0
Unfortunately there is no way to use SQL (that I know of) to ask DB2 for all its databases. Perhaps this is a difference between how DB2 is set up/managed versus other databases. A DB2 instance is essentially a database server. It does not do SQL per se as it is not a database. It is the "brains" or "guts" that runs the DB2 logic (and yes, it thus runs SQL, ...
2
DB2 Express-C version 10 and later no longer include a full suite of administration tools as part of the installer (the "Administration Tools" you installed might only include the ones you're looking at...).
Like MySQL and SQL Server, the administration tools are now available as a separate download.
The official tool you're looking for is IBM Data Studio, ...
1
You are missing the db2 drivers on the classpath for the java app.
2
The table MY_TBL contains large binary data in a BLOB column. The documentation of the REORG command says that DB2 avoids reorganizing such objects because it is time consuming and does not improve clustering. However, DB2 can be forced to reorganize LOB data if the LONGLOBDATA option is specified. The unused space can be reused by DB2, so inserting new data ...
3
Another approach is to use the Oracle Gateway for DB2 which can be used to create an Oracle database link to the DB2 database. Then use a SQL script to "pull" all the data from each table in turn by
insert into oracle_table select * from db2_table@dblink;
0
You export the data from Db2 and import into Oracle. There are considerations such as big-Endian, Unix vs Windows etc.
Here is a link:
http://www.ibm.com/developerworks/data/library/techarticle/dm-0505tham/
6
I'm going to take a guess that you are using automatic storage. (Not that this could happen otherwise...it is just easy to have this happen with automatic storage.)
The problem is most likely that your database reclaimed the space for itself but did not release the disk back to the operating system. This can be shown very easily by checking the High Water ...
1
Unfortunately, as the error description for SQL20058N reason code 10 states, you can't use an outer join with a refresh immediate MQT:
Explanation
...
10
The REFRESH IMMEDIATE option was specified and the FROM clause referenced more than one table.
User Response
10
Create the materialized query table as REFRESH DEFERRED, or use an inner join without the ...
0
It looks pretty normal for a server with a handful of databases with 5 or so clients per database.
0
db2fm is the Fault Monitor process and it fires up at least once per instance.
db2agent will probably fire up more than once because you can have more than one agent running per connection.
So to me this looks normal.
A good reference for this is the article "Everything You Wanted to Know About DB2 Universal Database Processes" on developerworks.
0
I think you may have answered your own question. I would use command line shell scripts. Seeing as you are on Linux, you have several to choose from (sh, ksh, and perl to name a few).
Another thing that could make things easier is if you catalog the remote server and database locally. Then you can connect to it and work with it without your script having to ...
0
You issue db2 connect from the same operating system where the server (database) is installed. In this case there is no difference between AUTHENTICATION=CLIENT and AUTHENTICATION=SERVER or SERVER_ENCRYPT (by the way, I believe the manuals strongly recommend against CLIENT setting).
If you are logged in as an OS user db2inst1, the DB2 will not doubt that OS ...
Top 50 recent answers are included
