Register | Login

Published Articles » Database

PGLIB=/opt/PostgreSQL/9.1/lib/
LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/
export PGDATA=/opt/PostgreSQL/9.1/data/
export PGDATA PGLIB LD_LIBRARY_PATH


Web design companies have Organized and Strategic Approach, which is the basic parameter of a successful website. Organizations have knowledge of latest technologies, which they use in website designing. Webnovators are the leading web development company in Australia. For more information, visit our website.


Is it possible to rename a column name?

Posted by jyothsnav 2217 days ago (Editorial)

Yes it is possible to rename a column name in DB2 V9.7 version online.


Exception: If the column to be renamed is a part of primary key, we should drop the primary key, rename the column and then recreate the primary key


Command:


ALTER TABLE <TABNAME> RENAME COLUMN <OLDNAME> TO <NEWNAME>


 


Launch the email client on your own mobile phone and look at inbox for a communication from Facebook.

Unfortunately, sometimes a bad apple efforts to ruin. Once one does, you are able to include an effective HTML hyperlink to Facebook or embed a Facebook widget.

Entity Relationship Diagrams

Posted by jyothsnav 2472 days ago (Editorial)

There are serveral notations for data modeling. The actual model is frequently called Entity Relationship model, because it depicts data in terms of the entities and relationships described in the data. An entity -relationship model (ERM) is an abstract conceptual representation of structured data. Entity-relationship modeling is a relational schema database modeling method, used in software e


How to find the last used date of an index

Posted by jyothsnav 2217 days ago (Editorial)

In earlier versions of DB2, we donot have the facility to find the last used date of an index. But in V9.7, this feature is available which will help us in analysing the real usage of that index and whether it is required.


Command:


SELECT LASTUSED FROM SYSCAT.INDEXES WHERE INDNAME='?'


OR


SELECT INDNAME,LASTUSED FROM SYSCAT.INDEXES WHERE TABNAME='?'


 

Want to read the subsequent message thread inside your inbox.

Data Modeling

Posted by jyothsnav 2472 days ago (Editorial)

Data modeling is the process of creating a data model by applying formal data model descriptions using data modeling techniques.


Data modeling is a method used to define and analyze data requirements needed to support the business process of an organization. The data requirements are recorded as a conceptual data model with associated data definitions.


Actual i

Error:
SQL0965C The transaction log for the database is full

Remedy:

1. Increase primary and secondary logs i.e.
In V9 - logprimary + logsecond=256
In V8 - logprimary + logsecond=250

db2 update db cfg for sample using logprimary X
db2 update db cfg for sample using logsecond X

2. Look for the query that is running, try modifying it by using where condition
3. Issue frequent c

DB2 Load Utility

Posted by jyothsnav 2461 days ago (Editorial)

Like the Import utility, the LAOD utility is designed to read data directly from an external file and store it in a specific table. However, unlike when the import utility is used, when the Load utility is used the table to which data is to be copied must already exist in the database before the load operation is initiated.


Syntax:


LOAD FROM [filename] OF [DEL|ASC|IXF]



Sort News
Username:

Password:

Remember:
YourWiz.com, is a website that will allow everyone to share their knowledge, tip or information through community micro blogging.