Search results for query: *

Did you make sure that the query returns results without the changes to 'ini' file? Your ini file looks ok to me.

db2 connect to <db_name> user <uid> using <pwd> db2 list tablespaces show detail db2 terminate Since you have a lot of tablespaces, you probably need to write a script to calculate the size. 1 tablespace is NOT equal to 1 table. Schema can span multiple tablespaces. Tables reside in a tablespace.

SYSCAT.DBAUTH SYSCAT.TABAUTH SYSCAT.INDEXAUTH SYSCAT.COLAUTH SYSCAT.SCHEMAAUTH SYSCAT.PASSTHRUAUTH SYSCAT.PACKAGEAUTH syscat.schemata

db2 list tablespaces show detail Multiply the number of free pages from each tablespace by the page size of the tablespace. Add all the tablespaces. For ex: Tablespace ID = 2 Name = USERSPACE1 Detailed explanation: Normal Total pages...

Assuming, stats are current : db2 "select tabname from syscat.tables where card >100000

To skip rollforward during restore: db2 restore db <db_name> from <backup_path> without rolling forward with prompting After you did a restore, did you do the following? db2 rollforward to end of logs and stop When the database is restored, the log files are deleted. After 1st connect, the...

Look into Federated Systems.

to see all the instances $db2ilist to see a list of the databases: $db2 list db directory When the backup command was issued, if there was a problem, it will complain or throw an error at that time itself. If there was a problem, then backup is not completed and it does not show up in the list...

yes. $db2 list history since 20051001 for db sample You can also do it from db2 interactive mode. At the prompt type db2 [and hit enter] $db2 this will take you into interactive mode : db2=> now you can just type in the command, without "db2" prefix. db2=>list history since 20051001 for db...

If the backup did not run properly it will complain immediately. To list all the backups already taken: list history backup all for db <db_name> To list backups since a particular period of time: list history backup since <time_stamp> for db <db_name> ex:db2 list history since 20051001 for db...

Maybe there are other utilities that are running at the same time you are doing your loads. You can check what other utilities are running using: list utilities show detail The easier option is to increase the util_heap_sz. [Maybe you can increase util_heap_sz some more temporarily during the...

When you do a UPDATE table SET condition; [without a where clause] you are updating the whole table. So, add a WHERE clause to your query, to restrict the update to only matching rows. UPDATE DVLT05.UPD_ACT_CNT U SET ACT_CNT = (SELECT M.ACT_CNT - 1) FROM DVLT05.MIN_ACT_CNT M WHERE...

SQL3011C There is not enough storage to process the command. Explanation: A memory allocation error occurred. Not enough memory is available to process the command, or there was an error freeing storage. The command cannot be processed. User Response: Stop the application. Possible...

this command will give a list of all the system tables/views, but not description : list tables for system

the Update syntax goes like : UPDATE table_name SET table_name.column_name=value WHERE condition you could probably improvise on this: update catentry set catentry.field4 = 'KM' where catentry.field2 IN (select catentry.field2 from manurel, catentry, catentdesc where manurel.manunbr IN...

Search Discovery - returns instance/databases on each machine on the local network[LAN]. Is the Linux server on the same LAN as the windows box?

thanks, Juliane. The problem is not at the client. I tried to connect to the database on the server itself and it would not let me connect. here is what I did: 1)db2 create db thai_db using codeset TIS620-1 territory TH COLLATE USING NLSCHAR DB20000I The CREATE DATABASE command completed...

Did you make sure DAS is running on the server[linux]? On the linux box, to make sure DAS is running do a : dbadmin start If it is already running it will say "The DB2 Administration Server is already active." otherwise it will start it.

thanks for looking into this. I was trying to create a [single-byte]database that can store data in thai as well as english, on Windows. I cannot use unicode due to some restrictions. I tried creating the database using the thai codeset[TIS620-1] and territory[TH]. But when I try to connect to...

http://www.alancsmith.co.uk/db2/olro/onlinero.html