Try doing this activity during off peak hours or after business hours
Increase the log file size so that it will be able handle the log writes
dewa81
Last Activity: Mar 2 '08, 06:12 PM
Joined: Jul 6 '07
Location:
-
Use like this
SELECT * FROM blah WHERE TIMESTAMP(DATE( col_date), TIME(col_time)) > '2007-08-08 15:38:00'Leave a comment:
-
update tableb a set col2=(select col2 from tablea b where a.col1=b.col1)
and a.col2 is nullLeave a comment:
-
user REORGCHK command to run runstats on all the tables of the databaseLeave a comment:
-
CONNECT TO <dbname>user <userid> using <'password'>;
EXPORT TO /dir/file1.txt OF DEL MESSAGES /dir/file1.msg SELECT * FROM <TABLE> WHERE <CLAUSE>;
<next export command>
..
.
.
.
.
.
commit;
CONNECT RESET;Leave a comment:
-
In your redirected restore command you should not specify TO CLAUSE unless the target database is not existing
If you are restoring to an existing database you should not mention that
Remove to "/dmd/data" from your restore command and try again, it will work
For the sftp problem either there are not enough permissions to write to the target directory or the space is exhaustedLeave a comment:
-
select account_id,carr ier_id,employer _group_id,count (employee_id) from employee
group by account_id,carr ier_id,employer _group_idLeave a comment:
-
select (current date) - 1 days from sysibm.sysdummy 1Leave a comment:
-
You can also setup a cron job in AIX and schedule itLeave a comment:
-
If you want to runstats on all the tables in the database we can accomplish this with just a single command
Connect to the database and run the follwing command
reorgchk update statisticsLeave a comment:
-
SPACE is not the same as NULL
So it is better to use if the column to be updated is a nullable column
EXEC SQL UPDATE DOEORDER
SET CHRG_CARD_NBR = NULL
WHERE ADD_TO_DB_DT < '2006-06-01'Leave a comment:
-
Refer this book - it is very good
Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows®
By Dwaine R. Snow, Thomas X. PhanLeave a comment:
-
Do u need the results rangewise or you want to select those rows which are in this mentioned range? Or you want to find the count of number of rows satisfying each range in a single query?Leave a comment:
-
What exactly you need?
If u want to find the sequence value u can use this query
select nextval for <seqname> from sysibm.sysdummy 1Leave a comment:
No activity results to display
Leave a comment: