How to dbImport in Informix?

1. dbimport <database_name> -d <dbspace_name> -l buffered

NOTE: l = small L

2. ontape -s -B <database_name>

3. Go to the folder <database_name>.exp

4. dbaccess <database_name> pp.sql

PLS-00123: Program Too Large when compile invalid objects in PL/ SQL ?

Go to PL/ SQL -> Tools -> Preferences -> Oracle Debugger:

a). Un-check the "Add debug information when compiling".

b). Click the "Apply" button.

c). Click the "OK" button.

d). Compile invalid objects now.

NOTE: In case you want to debug your package in PL/ SQL, you will need to check the "Add debug information when compiling" checkbox.

Set Define Off in Oracle

Oracle will ask you to enter the value if your UPDATE statement is written as below:

Update my_table Set my_field = 'You & I are good boy';

At the end, the value for my_field will not be updated even you have entered something.

To overcome this problem, you just need to add one more statement before the UPDATE statement:

Set Define Off;
Update my_table Set my_field = 'You & I are good boy';


NOTE: This topic also related to DELETE or INSERT INTO statement.

Shared memory not intialized for INFORMIXSERVER

The solution is:

a). Get the latest backup of the database. We assume there is ontape backup.

b). Do a ontape restore.

c). Load in the data until up-to-date.

oninit in Informix

oninit

The command is to start up the Informix database, in case it is in shut down mode.

oninit -iy

Take not that oninit -iy will clear all of the existing data in your Informix database. This is called "disk space initialisation".

It uses the values that are stored in the onconfig file to create the initial space on disk for storing data.

When you initialize disk space, the database server automatically initializes shared memory as part of the process.

When you initialize disk space, you overwrite whatever is on that disk space.

If you re-initialize disk space for an existing database server, all of the data in the earlier database server becomes inaccessible and destroyed.

Recall : HP Notebook PC Battery Pack

Original News: http://bpr.hpordercenter.com/hbpr/M14.aspx







In cooperation with the U.S. Consumer Product Safety Commission, on May 14, 2009. HP announced a worldwide voluntary recall and replacement program for battery packs used in certain HP notebook PCs. HP customers with a battery pack affected by this program will be eligible to receive a replacement battery pack for each verified and recalled battery pack at no cost.

We are taking this action as part of our commitment to provide the highest quality of service to our notebook customers. We are proactively notifying you of this issue and are prepared to replace all verified battery packs.

Note: This recall is unrelated to any previous battery pack recalls.

HP and the battery cell manufacturer believe that certain battery packs shipped in HP notebook PC products manufactured between August 2007and January 2008 may pose a potential safety hazard to customers. The batteries can overheat, posing a fire and burn hazard.

Click here for full announcement from HP official site