Search:

Type: Posts; User: mark.bb; Keyword(s):

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. 1. Why should "2012 and 2013" return X4C8C2 only,...

    1. Why should "2012 and 2013" return X4C8C2 only, if the person lived at X4S2B5 from 2012-01-01 to 2012-12-22?
    2. between 2012 and 2013 - is this:
    2012-01-01 - 2013-01-01
    or
    2012-01-01 -...
  2. Hi, What should the query return for dates which...

    Hi,
    What should the query return for dates which contain some eff_date?
    For example:
    2012 and 2013
    1990 and 1996
  3. Thread: tsa hadr vip

    by mark.bb
    Replies
    6
    Views
    7

    The TSA command to bring the resource online on...

    The TSA command to bring the resource online on the specific host is:

    startrsrc -s "Name='db2ip_10_16_0_136-rs' & NodeNameList='luechdb131'" IBM.ServiceIPbut you shouldn't run it until you...
  4. Thread: tsa hadr vip

    by mark.bb
    Replies
    6
    Views
    7

    TSA on db131 believes, that luechdb130 is down. ...

    TSA on db131 believes, that luechdb130 is down.

    Online IBM.Equivalency:db2_dbllua1_luechdb130_0-rg_group-equ
    '- Offline IBM.PeerNode:luechdb130:luechdb130 Node=OfflineIt's not good, you should...
  5. Thread: tsa hadr vip

    by mark.bb
    Replies
    6
    Views
    7

    Did I get it right that you want to bring the...

    Did I get it right that you want to bring the database IEEINT online?
    According to TSA you have:

    Offline IBM.ResourceGroup:db2_dbllua1_dbllua1_IEEINT-rg Request=Move(Online:O) Binding=Sacrificed...
  6. Thread: tsa hadr vip

    by mark.bb
    Replies
    6
    Views
    7

    What's the output of the following? lssam -s...

    What's the output of the following?

    lssam -s "Name like 'db2#_myinstance%'" -noequ -nocolor
    myinstance is your instance name.


    BTW,
    It's quite unusual to see the "the vip does not follow the...
  7. Replies
    4
    Views
    174

    Try this: select t.* , case when...

    Try this:

    select
    t.*
    , case when Interest_Rate BETWEEN .008 AND .016 AND Open_Date NOT BETWEEN date('2016-10-24') AND date('2017-01-01') AND Product_Name = 'Loans' then 'YES' else 'NO' end...
  8. Yes, it’s expected. If you want to raise a...

    Yes, it’s expected.
    If you want to raise a warning from SP, the SIGNAL statement must be the last statement executed there. Otherwise the warning is “eaten” by the next statement after the SIGNAL.
  9. Hi, There is possibility to do the same with...

    Hi,

    There is possibility to do the same with DB2.
    SIGNAL statement


    --#SET TERMINATOR @
    create or replace procedure raise_something(p_sqlstate char(5))
    begin
    declare l_msg varchar(70);
  10. Replies
    3
    Views
    135

    Seems, that you provided the access plans for the...

    Seems, that you provided the access plans for the query which selects all the table rows (predicate’s FF=1).
    There’s different number of rows in these tables.
    Since the query has ORDER BY clause,...
  11. Replies
    3
    Views
    135

    Hi, Can you provide both access plans for...

    Hi,

    Can you provide both access plans for ixscan and tbscan from the db2exfmt utility?

    db2 connect to mydb
    db2 set current explain mode explain
    db2 set current explain snapshot explain
    db2...
  12. Replies
    1
    Views
    186

    Every time you have some licensing doubts, you...

    Every time you have some licensing doubts, you should read the License Agreement document.
    You may not take into account any restrictions not listed there.
  13. You should bind from the client the following...

    You should bind from the client the following lists of bind files to iseries as described here:...
  14. Table access privileges are listed in the...

    Table access privileges are listed in the SYSCAT.TABAUTH system view.
    User groups, roles, users can have table privileges.

    Sometimes it can be a little bit complicated.
    Your user may belong to...
  15. Hello, According to the REVOKE (database...

    Hello,

    According to the REVOKE (database authorities) statement, you have to find an eligible user for such a statement.
    Use the following statement to find such a user:

    select granteetype,...
  16. This is an sql statement. So, it doesn't matter...

    This is an sql statement. So, it doesn't matter where your tool issuing this statement is running.
    CLI bind files and package names.
    These packages are used to support DB2 CLI/ODBC calls.
  17. Try this from the user account with the...

    Try this from the user account with the appropriate authorizations:

    db2 "grant execute on package NULLID.SYSSH200 to public"
  18. Hi, Try this: select name, value from...

    Hi,

    Try this:

    select name, value from sysibmadm.dbcfg where name like 'code%'
  19. db2 CREATE DATABASE data2 USING CODESET UTF-8...

    db2 CREATE DATABASE data2 USING CODESET UTF-8 TERRITORY XX COLLATE USING IDENTITY
    XX influences date and time formats, and not the sort order.
    Date and time formats by territory code
  20. There is no such a client setting making the...

    There is no such a client setting making the driver sort the result set itself.
  21. Hi, Try this: select * from admin.tab order...

    Hi,

    Try this:

    select * from admin.tab order by COLLATION_KEY_BIT(col1, 'SYSTEM_1250_SI')
  22. Hi, What are the sizes of the db2rhist.asc...

    Hi,

    What are the sizes of the db2rhist.asc files on both your "quick" and "slow" systems?
    Have you compared the io characteristics of the file systems containing this file on both systems?
    ...
  23. Hi, Try this: select name , sum(case...

    Hi,

    Try this:

    select
    name
    , sum(case project when 'project1' then num end) project1
    , sum(case project when 'project2' then num end) project2
    from (
    select
  24. Replies
    6
    Views
    322

    It's good to show the following output: select...

    It's good to show the following output:

    select versionnumber, version_timestamp from sysibm.sysversions
  25. Replies
    6
    Views
    322

    Hi, You should have the same function in 8.2:...

    Hi,

    You should have the same function in 8.2:
    https://www.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0007102.html
Results 1 to 25 of 302
Page 1 of 13 1 2 3 4