New answers tagged db2
There's no separate "trigger performance impact"; trigger code is essentially compiled into the execution plan of the statement that causes the trigger to fire, so measuring average DML statement response time before and after introduction of triggers should give you a general idea of the impact. Of course, triggered actions will certainly affect other ...
It appears to be long column name versus short column name. Upon closer inspection the hidden column always had the same value as an unhidden one. Since the long name in this case was abbreviated and cryptic, I didn't make that connection right away.
There is an IMPLICITLY HIDDEN column attribute that can be applied. Please check for this... This means the column will only appear when it is explicitly specified on the SELECT statement. Check the CREATE TABLE statement for this property, or materialize the TABLE's DDL using some API or tool, such as RTVSQLSRC.
There are several options because DB2 LUW has the older snapshot monitoring and a new monitoring facility integrated into the Workload Manager. Both facilities offer views and table functions to consume the data as well as tools on top. For an easy way to start I would suggest to use db2top. Connect to a database and use, e.g., "D" to go to the Dynamic SQL ...
I guess I got the answer. Its not a part of DB2. But its a feature of SecureSphere. As SecureSphere captured the user name as Hashed User and its a security feature of SecureSphere that when SecureSphere encounters user names it cannot decrypt it will put it as "Hashed User".
Never heard of the term "hashed user". If this applies to user management: DB2 relies on external services such as the operating system for user management. DB2 supports hash joins and several algorithms are based on hashing.
In PostgreSQL, you can use Text Search: create index on foo_table using gin ( to_tsvector('simple', body) ); select * from foo_table where to_tsvector('simple', body) @@ plainto_tsquery('simple', 'word');
Sum after you did the union (hope DB2 does it this way): SELECT BRAND, BRAND_GROUP, SUB_BRAND, SUM(INCOME) AS TOTAL_INCOME FROM (SELECT BRAND, BRAND_GROUP, SUB_BRAND, INCOME FROM "tema".MMT WHERE BRAND_GROUP IS NULL AND SUB_BRAND IS NULL UNION ALL SELECT BRAND, BRAND_GROUP, SUB_BRAND, INCOME ...
Like @mustaccio pointed out, you need to select into something, and you need to declare the handler before the actual code. Something like: create or replace function is_decimal(c_data varchar(100)) RETURNS INTEGER begin declare t decimal(12,10); DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING BEGIN return 0; END; select cast(c_data as ...
Top 50 recent answers are included