Hi,
I am facing some strange issue in DB2 UDB 9.5.1

I have created a database on DPF implemented environment and I tried
to execute following commands

Db2 create table test ( name char(10) not null, acno integer not
null );
Completed successfuly

Db2 alter table test add constraint PK_test primary key ( acno );
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0108N The name "PK_TEST" has the wrong number of qualifiers.
SQLSTATE=42601

But if I create primary key on first column ( Db2 alter table test add
constraint PK_test primary key ( name ))
it works fine. I am not sure whether it is related to DPF or Db2
version.

Please help.

In version 8.2 ESE we used alternate fixpacks to allow multiple fixpack
levels for different instances, and to allow an instance to be deprecated
back to the previous fixpack (with certain limitations).

In looking at V9.5 install procedures there are no alternate fixpacks. There
is only a db2_install and a installFixPack script (not counting the db2setup
GUI program).

It looks to me like the installFixPack script is used to update (overlay) an
existing install (not add a separate set of binaries like an alternate
fixpack in 8.2) and that db2_install using a new directory should be used to
emulate the functionality of the an alternate fixpack in V8.2.

Is this interpretation correct?

hi

I have to use
"set current refresh age any" and
"set current maintained table types for optimization all"
to let optimizer pick my user-maintained MQT.

I wish to set this permanently in db2, rather than setting it in each
session. Is there a way to do so?

thanks

Hi,
I am getting the error "SQL0101N The statement is too long or too
complex. SQLSTATE=54001" while trying to rebind a package on the
database. I am connected as instance owner.Here's the info on the UDB
software installed on db server -
DB21085I Instance "pdpd154" uses "32" bits and DB2 code release
"SQL08021"
with level identifier "03020106".
Informational tokens are "DB2 v8.1.0.83", "special_14190",
"U803800_14190", and
FixPak "8".
Product is installed at "/opt/IBM/db2/V8.1".

I am a San Francisco Bay Area recruiter looking for very experienced
UDB LUW DBA’s for both Northern and Southern California locations.
Ten years of DBA experience with extensive knowledge of DB2 UDB
performance monitoring and tuning procedures, as well as, UDB ULW,
DPF, UNIX Shell scripting and expert SQL skills to rewrite complex
queries for performance improvement are required. Also desired are SQL
Server, Oracle, BMC Patrol and DB2 Connect experience. These are a
regular full time employee opportunities. Lead, Manager and Consultant
positions are available.
If this is of interest, please forward me your confidential resume and
let’s talk.
Thank you- David Pilati
Executive Recruiter
MIS Consulting Group
david@mis-consulting.net
510-666-9642

Hy,
we have an "old" but running db2 V7.2 server running on OS/2 Warp.
We would like to access it from a Linux Ubuntu machine.
What client should we install ?
Can V9 client access a V7.2 server ?
If not do you have any other solution ?

Thanks

When running an export:

export to css.ixf of ixf select css_id, service, client_id, site_id,
css_label, css_abbr, sos_flag, city, state, 'N', 'N' from
userid.css_defn

It returns an error: SQL27984W Some information has not been saved to
the PC/IXF file during Export. This file will not be supported in
Import CREATE mode. Reason code="7".

Reason code 7 states: 7 Action strings other than 'SELECT * FROM
' are not supported.

Is this related to the data? Because we have run this statement in
the past without this error.

Hello,

Env: DB2 V8 LUW FP16 running Linux

create Table X (machine_id varchar(24) not null, ctime timestamp not
null);
create index iFoo on X (MACHINE_ID, CTIME) allow reverse scans;
alter table X add primary key (MACHINE_ID, CTIME);

Our C++ application inserts data into a table X using CLI array insert
with very good throughput.

On an hourly basis, another application (running on a different
server) reads the last 'hour':

select * from T where MACHINE_ID = ? and ctime between current
timestamp - 1 hour and current timestamp for read only;

After that, it starts a delete loop:

while (SQLCODE <> 100 )
do
delete from (select 1 from T where MACHINE_ID = ? and CTIME between
current timestamp - 1 hour and current timestamp fetch first 2000 rows
only) as B
done

Please let me know if you’d have any suitable reference for the
following requirement

Consultant and Developer for DB2 Performance Benchmarks and Solutions
Location : Bangalore

Required:
• DB2 Consultant with at least 2 years experience in Perform
Performance Analysis
• Experience in C, Java, scripting (e.g. Perl, shell script, etc),
SQL,
• ODBC, JDBC, J2EE and XML
• Experience with at least one of UNIX, Linux, or Windows
• Experience with the following would be an asset:
o Performance testing methodology and tools.
o Administering, monitoring, and tuning skill

Interested candidates are requested to send in their resumes in Word
format to Michael.v@pyramidconsultinginc.com

Please let me know if you’d have any suitable reference for the
following requirement

Consultant and Developer for DB2 Performance Benchmarks and Solutions
Location : Bangalore

Required:
• DB2 Consultant with at least 2 years experience in Perform
Performance Analysis
• Experience in C, Java, scripting (e.g. Perl, shell script, etc),
SQL,
• ODBC, JDBC, J2EE and XML
• Experience with at least one of UNIX, Linux, or Windows
• Experience with the following would be an asset:
o Performance testing methodology and tools.
o Administering, monitoring, and tuning skill

Interested candidates are requested to send in their resumes in Word
format to Michael.v@pyramidconsultinginc.com