Archive for

Why IE losing markets share?

Posted in General with tags , , , , , , , on November 5, 2011 by DBAWork

IE can no longer entitlement more than half of the web’s transportation, as of October, completion more than a decade era of the default Microsoft browser’s reign.

Safari’s hold on 62.17% of traveling traffic has reduced IE’s largely share of web surfing, even though still ask for 52.63% of desktop transportation, according to

The IE’s shrinking share (49.6%) echoes its near nonexistence from the realms of mobile and tablet, which now make up 6% of web transportation. Still, probabilities are, you gave up on IE long enough ago that this landmark makes you more probing as to who actually still uses the browser.

Does this mean the termination of IE as we discern it? Not at all. As specified, straight with it tumbling under the intermediate point in terms of norm, at 49.58 percent of the market share, IE still holds further users than the other listed browsers. According to the report from NetMarketShare, via, Internet Explorer’s two major challengers, Firefox and Chrome, have a collective market share of 37.8 percent. It’s only after you sum in the stretch of Safari, Opera and the ubiquitous other browser (8.54%, 1.49%, and 2.59%), does the entire figure conceal IE’s share.

As of Oct, Firefox is the subsequent further most widespread web browser, counting for 21.20% of traffic, charted by Google Chrome and Safari, which account for 16.60% and 8.72% individually.

Database SupportDatabase support, Database services, Oracle ADF


Wi-Fi System – Does it needs improvement?

Posted in Uncategorized with tags , , , , , , , , , , on October 29, 2011 by DBAWork

As the world is becoming small with more usage of internet, companies setup Wi-Fi system in their campus to have ready available of internet for their employee, guest.

With these Wi-Fi systems the campus of the company gets converted into work area. You can work while you are taking a cup of coffee in cafeteria. You don’t have to bother about the mail; because you can connect your Smartphone’s to Wi-Fi system and access them at any place. Vendor or visitors can access internet through the wi-fi system.

One survey was done to check the Wi-Fi status in upper management circle. Some of surprising things can be observed from this survey.

10% of companies don’t have Wi-Fi network.

Like companies are very careful while delegating the wi-fi access. They don’t want any other person to go into their network. One more thing which we need to understand is that, they feel it is not that secure to provide access.

25% companies have secured wi-fi network.

Companies provide guest access with secured authentication. For guest access as well you need to authenticate your self.

5% of companies don’t provide guest access

These companies have wi-fi but they don’t provide guest access. This means not guest or not secured authenticated network for the outsider.

These were problem with the older wi-fi system. The re-new Wi-Fi system can have separate guest network, which will be separated from corporate network. The mobile device are more ‘aggressive’ in usage of wi-fi system, rather than laptop.  In the university campus it is like one particular video needed to be accessed by many students. As the Wi-Fi system is not intelligent system, it goes to access each and every request.

Wi-Fi companies are working on these area, wi-fi is not just a wireless connectivity it has become more than that.

Database Support, DBAWorkDatabase support, Database services, Oracle ADF

World will go back to analog age

Posted in Uncategorized with tags , , , , , , , , , , on October 28, 2011 by DBAWork

As we know the digital equipments can hold only zero and one, which makes boundaries for its working in computer. Since the flash drive and RAM can’t hold the data after power failure, we need to let server come back to normal state. We can’t think of starting working when we have shutdown the system. Because of this ram and hard disk the computer are bulky in size.
Now there is a good news, a revolutionary news which will make your computer to fit in your pocket, still it will run 10 to 20 times faster than what we have. We don’t need to restart the computer after the computer is shut down because of some power failure. The technology we are talking about is very chip.

It is called as Memristor.

This is analog device. It can remember how much current has passed thought it. And by alternating the amount of current that passes through it, a memristor can also become a one-element circuit component with unique properties. Most notably, it can save its electronic state even when the current is turned off, making it a great candidate to replace today’s flash memory.

Memristors will tentatively be cheaper and far quicker than flash memory, and allow far superior memory densities. They could also substitute RAM chips as we know them, so that, after you turn off your workstation, it will remember accurately what it was doing when you turn it back on, and return to work immediately. This lowering of cost and consolidating of components may lead to inexpensive, solid-state computers that fit in your pocket and run many times quicker than today’s PCs.
In the future the memristor could spawn a whole new type of workstation, thanks to its capability to remember a range of electrical states rather than the one-dimensional “on” and “off” states that today’s digital processors be acquainted with. By operational with a dynamic range of data states in an analog mode, memristor-based computers could be proficient of far more difficult tasks than just shuttling ones and zeroes around.
Researchers say that no real barricade prevents implementing the memristor in circuitry straight away. But it’s up to the business side to push products through to business reality. Memristors made to replace flash memory (at a lower cost and lower power utilization) will likely appear first; HP’s goal is to offer them by 2012. Beyond that, memristors will likely swap both DRAM and hard disks in the 2014-to-2016 time outline. As for memristor-based analog computer, that step may acquire 20-plus years.

As this going to affect the every part of system, it will affect the database as well.

Database Support,DBAWorkDatabase support, Database services, Oracle ADF

DB2PD – Diagnosing a lockwait

Posted in DB2 with tags on September 1, 2011 by DBAWork

In RDBMS database, to validate data integrity, it has concept called as lockwait. Lockwait goes like wait on lock to be released by another application. The time which is need to get hold of perticular resource by holding lock is measured in time.

DB2 has tool which provides a way to diagnose lockwait condition. Following is example of this.

If you run db2pd -db databasename-locks -transactions -applications -dynamic, the results are similar to the following ones:

Address            TranHdl Lockname                   Type Mode Sts Owner Dur HldCnt Att    ReleaseFlg
0x07800000202E5238 3       00020002000000040000000052 Row  ..X  G   3     1   0      0x0000 0x40000000
0x07800000202E4668 2       00020002000000040000000052 Row  ..X  W*  2     1   0      0x0000 0x40000000

For the database that you specified using the -db database name option, the first results show the locks for that database. The results show that TranHdl 2 is waiting on a lock held by TranHdl 3.

Address            AppHandl [nod-index] TranHdl Locks State Tflag      Tflag2     Firstlsn       Lastlsn        LogSpace SpaceReserved TID            AxRegCnt GXID
0x0780000020251B80 11       [000-00011] 2       4     READ  0x00000000 0x00000000 0x000000000000 0x000000000000 0        0             0x0000000000B7 1        0
0x0780000020252900 12       [000-00012] 3       4     WRITE 0x00000000 0x00000000 0x000000FA000C 0x000000FA000C 113      154           0x0000000000B8 1        0

We can see that TranHdl 2 is associated with AppHandl 11 and TranHdl 3 is associated with AppHandl 12.

Address            AppHandl [nod-index] NumAgents CoorPid Status        C-AnchID C-StmtUID L-AnchID L-StmtUID Appid

0x07800000006879E0 12       [000-00012] 1         1073336 UOW-Waiting   0        0         17       1         *LOCAL.burford.060303225602
0x0780000000685E80 11       [000-00011] 1         1040570 UOW-Executing 17       1         94       1         *LOCAL.burford.060303225601

We can see that AppHandl 12 last ran dynamic statement 17, 1. ApplHandl 11 is currently running dynamic statement 17, 1 and last ran statement 94, 1.

Dynamic SQL Statements:
Address            AnchID StmtUID NumEnv NumVar NumRef NumExe Text
0x07800000209FD800 17     1       1      1      2      2      update pdtest set c1 = 5
0x07800000209FCCC0 94     1       1      1      2      2      set lock mode to wait 1

We can see that the text column shows the SQL statements that are associated with the lock timeout.

Database DB2 Support, DBAWorkDatabase support, Database services, Oracle ADF

Quick Reference for DB2 installation

Posted in DB2 with tags on September 1, 2011 by DBAWork

Please follow this process to install DB2 V9.1.


Login as root to this system. As we need to create certain user group and users. Following commands will allow you to create user with needed path for home directory. We will need to create user and set its password as well.
* Create groups:
o groupadd -g 999 db2iadm1
o groupadd -g 998 db2fadm1
o groupadd -g 997 dasadm1

* Create users for each group:
o useradd -u 1004 -g db2iadm1 -m -d /home/db2inst1 db2inst1
o useradd -u 1003 -g db2fadm1 -m -d /home/db2fenc1 db2fenc1
o useradd -u 1002 -g dasadm1 -m -d /home/dasusr1 dasusr1

* Set password for each users created:
o passwd db2inst1
o passwd db2fenc1
o passwd dasusr1

* cd to installation file directory:
o Example: /tmp/db2/exp/disk1

* Run installation script:
o ./

Post Install

* Login as root.
* Install license (example):
o /opt/ibm/db2/V9.1/adm/db2licm –a /tmp/db2/exp/disk1/db2/license/db2exp_uw.lic

Create the DB2 Administration Server (DAS)

* Login as root.
* Create DAS with dasusr1
o /opt/ibm/db2/V9.1/instance/dascrt -u dasusr1

* Login as dasuser1
o Start the DAS: db2admin start

* Optional: to enable autostarting of the DAS upon reboot
o /opt/ibm/db2/V9.1/instance/dascrt/dasauto –on

Create DB2 instance

* Login as root.
* Create instance with users db2fenc1 and db2inst1:
o /opt/ibm/db2/V9.1/instance/db2icrt -a server -u db2fenc1 db2inst1
* Optional: enable autostarting of the db2inst1 instance
o /opt/ibm/db2/V9.1/instance/db2iauto –on db2inst1

Update environment variables

* Example:
* Login as db2inst1
* edit .bash_profile
o vi /home/db2inst1/.bash_profile
o insert the following line at the end of the file – “. /home/db2inst1/sqllib/db2profile”

* Do the same for dasusr1, using its corresponding directory.

Database service

* Login as root:
* Add new service entry:
o vi etc/services
o insert this line “DB2_TMINST 50000/tcp” at the end of the file


* Login as db2inst1
* List installed DB2 products and features: db2ls
* Display the default instance: db2 get instance
o Result: The current database manager instance is: db2inst1
* Start the database instance: db2start
o Result: SQL1063N DB2START processing was successful.
* Stop the database instance: db2stop
o Result: SQL1064N DB2STOP processing was successful.

Remote Database Support,DBAWorkDatabase support, Database services, Oracle ADF

Data movement using cursor and bulk insert – Oracle 11g

Posted in Oracle, Uncategorized with tags , , , , , , , on August 22, 2011 by DBAWork

If you want to store a collection of data from a cursor into a table, the “BULK COLLECT INTO, FORALL INSERT” in Oracle is a friend. Instead of iterating row-by-row through the cursor, BULK processes data in a batch mode at the background.

The syntax is a bit different in Oracle 10g and 11g. In the examples below, we will insert all the data from cursor into a table


The result set in the cursor has the same columns as the target table. Therefore, in 11g, we can simply code like

myrecord_tab myrecord_tab_type;

FETCH ref_cursor BULK COLLECT INTO myrecord_tab;

FORALL i IN 1 .. myrecord_tab.count
INTO mytest
VALUES myrecord_tab(i);

In 10g, the code needs to be different and needs to use DBMS_SQL.XXXX_TABLE.

TYPE myrecord_tab_type IS RECORD
myrecord_tab myrecord_tab_type;


FORALL i IN 1 ..
INTO mytest(object_name, object_id, created)

Remote Oracle Support,DBAWorkDatabase support, Database services, Oracle ADF

SQL Server 2008 – New Features

Posted in SQL Server with tags on August 18, 2011 by DBAWork

Transparent Data Encryption

Empower encryption of an complete database, data files, or log files, without the requisite for application deviations. Benefits of this include: Search encrypted data using both range and fuzzy searches, exploration secure data from unapproved users, and data encryption without any mandatory variations in existing applications

Extensible Key Management

SQL Server 2005 provides a wide-ranging solution for encryption and key managing. SQL Server 2008 transports an exceptional solution to this increasing need by supporting third-party key management and HSM merchandises.


Craft and manage inspecting via DDL, while simplifying acquiescence by providing more comprehensive data auditing. This enables establishments to answer common questions, such as, “What data was recovered?”

Improved Database Mirroring

SQL Server 2008 builds on SQL Server 2005 by providing a supplementary trustworthy platform that has enriched database mirroring, including spontaneous page repair, enhanced performance, and improved supportability.

Automatic Recovery of Data Pages

SQL Server 2008 enables the foremost and mirror machines to evidently recover from 823/824 types of data page miscalculations by requesting a fresh copy of the suspect page from the mirroring partner transparently to end users and applications.

Database SQL server Support, DBAWorkDatabase support, Database services, Oracle ADF