db2

Tag details

Welcome to the 'db2' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'db2'.

Are you an expert about 'db2'? Do you want to be the Technorati authority on 'db2'? You can write a description that will appear right here: Join Blogcritics!

Look up Offsite Link "db2" at The Free Dictionary

Latest blogosphere posts tagged “db2”
 

  • VMware vCenter Server 5.1 fails after demoting Windows Domain Controller


    Authority Authority:
    Last week a colleague of us was tied up with troubleshooting a VMware environment with a vCenter Server which failed authenticating through LDAP with the Windows Domain. He was demoting two old domain controllers from the Windows domain which became obsolete after creating new virtual machines to replace the old ...
    6 days ago
  • DB2- Creating Table Spaces


    Authority Authority:
    There are 3 types of Db2 table spaces. Universal Partition-By-Growth (PBG) table spaces. Universal Partition-By-Range (PBR) table spaces Segmented Tables spaces There are LOB and XML table spaces. PBG- Is the default table space. LOB table spaces will be used for BLOB,CLOB and DBCLOB. General Rule: Let ...
    6 days ago
  • ADM5500W DB2 is performing lock escalation


    DBA DB2Authority Authority: 92
    ADM5500W  DB2 is performing lock escalation.  The total number of  locks currently held is "817", and the target number of locks to hold  is "408".    How can I resolve?   Check the current LOCKLIST level with :    db2 get db cfg for COMMDB | grep LOCKLIST Increase the database locklist size to ...
    1 week ago
  • IBM DB2 with BLU Acceleration improves analytical performance


    Authority Authority:
    With DB2 10.5, you have the option to insert data into the database as columnar-ordered data sets that compress the data as it is being loaded. Because of the high compression rate, DB2 can work with more data in memory than before. Continue reading
    2 weeks ago
  • What Every Database Administrator Should Know About Security


    Authority Authority:
    [The following is excerpted from "What Every Database Administrator Should Know About Security," a new report posted this week on Dark Readings  Database Security Tech Center .] To say that there is friction between security professionals and database administrators (DBAs) is putting it mildly. Database ...
    2 weeks ago
  • Uptime of DB2 LUW


    DBA DB2Authority Authority: 92
    How can you find the uptime of DB2 LUW ? Checking the  uptime for DB2 LUW is  achieved through the command line processor (CLP).Issue this command through the CLP. I normally use Putty as a client to access the CLP   db2pd - --sample output Database Partition 0 -- Active -- Up 27 days 18:27:05--For ...
    3 weeks ago
  • IBM BLU


    Authority Authority:
    I had a good chat with IBM about IBM BLU, aka BLU Accelerator or Accleration. BLU basics start: BLU is a part of DB2. BLU works like a columnar analytic DBMS. If you want to do a join combining BLU and non-BLU tables, all the BLU tables are joined first, and the result set is joined to the other tables by the rest ...
    3 weeks ago
  • Data skipping


    Authority Authority:
    Way back in 2006, I wrote about a cool Netezza feature called the zone map , which in essence allows you to do partition elimination even in the absence of strict range partitioning. Netezza’s substitute for range partitioning is very simple. Netezza features “zone maps,” which note the minimum and ...
    3 weeks ago
  • Shoe Fetish or Benchmark Comparison ?


    Authority Authority:
    Last month I visited the Fashion Institute of Technology’s new exhibit “Shoe Obsession.” And for anyone who relishes shoes, this was the place to be. You enter the dark rooms and the glass cases are absolutely glowing in light, highlighting the SHOES. There’s Manolo Blahnik, Christian Louboutin, Prada and ...
    3 weeks ago
  • Database Scripts for creating custom user repository in DB2


    Authority Authority:
    Apart from the scripts that are required to setup the mandatory Portal databases, you might also want to setup user own user repository in DB2 database. The following script will create a database in DB2 for storing user credentials. This database can be used to create a custom user repository in DB2 and use the same ...
    4 weeks ago
  • Database Scripts for creating Portal database on DB2


    Authority Authority:
    For migrating WebSphere Portal database from Derby (default portal database) to other database like DB2 you need to first create the databases in DB2. Portal uses following 6 databases to store different kind of information so the first step is to create the following databases in DB2. 1. Release 2. Community 3. ...
    4 weeks ago
  • Remove Duplicate Records from a DB2 Table


    Authority Authority:
    I was recently trying to add a unique index on a table, and it gave me an error that the index could not be created because the table contained duplicate records across the fields I was trying to use in … Continue reading →
    4 weeks ago
  • ERP system enhancement by kikoz


    Pro Freelance ProjectsAuthority Authority: 159
    I am working on enhancement of ERP system and need some help with building web interface, Python django, db2, sql (Budget: $15-$25 USD, Jobs: Django, Graphic Design, HTML, Python, Website Design) Go to Source
    4 weeks ago
  • How to list UDF in DB2


    DBA DB2Authority Authority: 92
    UDF in DB2 . How can I view  details on user defined functions? To view user defined functions - UDF in DB2–  use the SYSCAT.ROUTINES catalog view to return a full list of user defined functions including – scalar function , table function, sourced function, method and procedure. The example query returns ...
    4 weeks ago
  • Join the DB2 Twitter Q&A Tomorrow!


    Authority Authority:
    Join us for our next live Q&A session on Twitter tomorrow at 4pm BST. This is your chance to put questions to our panel of DB2 experts.  Follow #DB2Geek on Twitter to see all of the questions and answers.  This is … Continue reading →
    4 weeks ago
  • Some stuff I’m working on


    Authority Authority:
    1. I have some posts up on Strategic Messaging . The most recent are overviews of messaging , pricing , and positioning . 2. Numerous vendors are blending SQL and JSON management in their short-request DBMS . It will take some more work for me to have a strong opinion about the merits/demerits of various ...
    4 weeks ago

Comments about db2

Personal attacks are NOT allowed
Please read our comment policy