New answers tagged db2
You cannot alter the LOGGED attribute of a LOB column. However, you can alter the table by adding a new LOGGED LOB column, update the new column from the existing column, then drop the original column. It may require less wasted disk space but is unlikely to be faster than using ALTOBJ.
Sounds like you are not properly deallocating objects like Statement, ResultSet, etc., so your application is holding open statement handles in the database. This will eventually exhaust "CLI Packages" in the database, resulting in the SQL0805N error. The proper solution is to make sure that you close these as soon as you're done reading them. You may ...
Have you tried GROUPING SETS? Something like: SELECT CS_YEAR AS YEAR, CS_MNTH AS MONTH, CS_WK AS WEEK_NO, COALESCE(COST_CARRIER, 'Total') AS COST_CARRIER, COALESCE(COST_CARRIER_CD, 'Total') AS COST_CARRIER_CD, SUM(CS_WG_CST) AS WAGE_COST, SUM(CS_PART_CST) AS MATERIAL_COST, SUM(CS_DH_CST) AS ...
It really depends on your main goal - if it should look 100% like your result in the question above then I am sorry the answer is no. If you want to get a result with the sum etc. yes there are ways round the union but you might not see the "Total" text. Here is one solution idea (with less data and columns as I could not extract it from your question). ...
In DB2, the SQL Server's recovery model simple equivalent is called circular. <p>C:\WINDOWS\system32>db2 get db cfg for sample |findstr "LOGARCHMETH1 LOGARCHMETH2" <\p> <p> First log archive method (LOGARCHMETH1) = OFF </p> <p> Second log archive method (LOGARCHMETH2) = OFF </p> If both ...
The minimum requirement is to have DB2 10.1.4 or DB2 10.5 installed. -createdb: Generate the CREATE DATABASE command that was used to create the source database db2look -d sample -createdb
I just had the same problem! In my case the problem was just the memory of the DB2 instance. In windows type: db2 get dbm cfg | findstr MEMORY In linux: db2 get dbm cfg | grep MEMORY You will get something like that: Global instance memory (4KB) (INSTANCE_MEMORY) = 500000 The solution in my case was simply set the same threshold value but ...
Taken from DB2 UDB security. User and group authentication is managed in a facility external to DB2 UDB, such as the operating system, a domain controller, or a Kerberos security system. This is different from other database management systems (DBMSs), such as Oracle and SQL Server. +info? please click here ...
the upper limit of log file size, combined with the upper limit of the number of log files (logprimary + logsecond), gives an upper limit of 1024 GB of active log space. You can increase the size of the log file size setting by issuing the command: db2 UPDATE db cfg for <databaseName> using LOGFILSIZ <new_value>
Top 50 recent answers are included