Discussions - comp.databases.ibm-db2

	How to fix duplicate SSN without table recreration?
	I created on home PC a table more than 1 Million rows using example from DB2 COOKBOOK: CREATE TABLE PERSONNEL (EMP# INTEGER NOT NULL ,SOCSEC# CHAR(11) NOT NULL ,JOB_FTN CHAR(4) NOT NULL ,DEPT SMALLINT NOT NULL ,SALARY DECIMAL(7,2) NOT NULL ,DATE_BN DATE NOT NULL WITH DEFAULT ,FST_NAME VARCHAR(20) ,LST_NAME VARCHAR(20)... more » By lenygold via DBMonster.com - Sep 7 - 2 new of 2 messages

	Potential abolition of leap seconds - USNO impact survey
	I thought the following link could be of interest: The USNO is conducting a poll for the DoD about leap seconds. [link] I note in the description that they do not recognize the possiblity of having a leap-free broadcast time scale while still allowing leap seconds in UTC. Those really are two separate questions.... more » By Robert Jones - Sep 7 - 1 new of 1 message

	How to learn IBM-DB2
	Hi, I'm learning what database is and how it works these days, I choose IBM DB2 express V9.5 as my DBMS(DataBase Management System), but I'm have no idea how to use it properly. Now I'm wondering is there a better and efficient way to learn and use this software? By Yee.Chuang - Sep 7 - 3 new of 3 messages

Can we create UDF using View instead of table

Hi everybody! I have a UDF. It is working fine. But when i try apply the same UDF to a view it is not working. CREATE VIEW SSN_SORTED AS WITH TEMP(EMP#,SOCSEC#,JOB_FTN,DEPT ,SALARY,DATE_BN,FST_NAME,LST_N AME) AS (SELECT MAX(EMP#),MAX(SOCSEC#),MAX(JOB _FTN),MAX(DEPT),MAX(SALARY),MA X(DATE_BN) ,MAX(FST_NAME),MAX(LST_NAME)... more »

By lenygold via DBMonster.com - Sep 6 - 3 new of 3 messages

	change in rand function or the way function is called from procedure, V8.2 -> V9.5?
	In one of our use cases we generate a random number for each participant. We initialize the rand generation with a known seed in order to be able to repeat the selection later on (regression test etc). This no longer works the same way in 9.5 compared to how it used to work in 8.2. I have compiled a small example that will demonstrate... more » By Lennart - Sep 5 - 4 new of 4 messages

	what is DB2INSTDEF
	Hello, Just upgraded to 9.1 fp3 from 8.2 (linux) Noticed the db2set variable: db2instdef Can some expalin what this variable name holds. Does this replace the other db2set variable : db2instance thanks Pete. By peter sands - Sep 4 - 2 new of 2 messages

	default timestamp value and performance
	I know this could be a dumb question, I just want to confirm that it is faster to execute inserts, if a timestamp field is set to have a default value, like DEFAULT CURRENT TIMESTAMP, and skip that column in inserts, than to include explicit timestamps in the inserts and let the DB insert them. Thanks!... more » By Henry J. - Sep 4 - 6 new of 6 messages

	DB2 taking a long time to start archiving logs
	For some reason, DB2 is taking a long time to start archiving the logs. Pls, do you know what could be causing it? I see the following msgs on db2diag.log 2008-09-04-00.36.24.414103+000 I415281A322 LEVEL: Warning PID : 1585198 TID : 1 PROC : db2loggr (SGPPBWG2) 0 INSTANCE: ucsdb2 NODE : 000 DB : SGPPBWG2... more » By eliane - Sep 4 - 5 new of 5 messages

	SQLCACHE_SNAPSHOT function returns no records.
	Running 8.2.8 on aix. Any reason why the dynamic cache snapshot function would return no records? db2 "SELECT * FROM TABLE (SQLCACHE_SNAPSHOT()) as SQLCACHE_SNAPSHOT" 0 record(s) selected. I can see that there is dynamic sql in the cache from "db2 get snapshot". By Patrick Finnegan - Sep 3 - 4 new of 4 messages

	db2ckpwd not running under root
	We have a small problem in one of our database hosts in which the db2ckpwd daemon process runs under the instance owner id instead of "root". Due to this, no other id except the instance owner is able to start the database instance. I see the following error messages in the diag if a 'db2start' is attempted by any other id:... more » By db2dude - Sep 2 - 3 new of 3 messages