Recent content by matchum

Stoggers, Thanks for that but ROW_NUMBER assumes ODBC-base (unless I misread the manual). I will examine it in more detail tomorrow. In the mean time, if you have any method for quickly allowing the above command file (command.txt) to be driven via (say) db2 -tvf command.txt, then I would be...

I have a command table containing: ---********************************--- connect to sample; drop table emp1; create table emp1 like employee; insert into emp1 select * from employee -- fetch first 5 rows ; select count(*) from emp1; connect reset...

gabegg, Interestingly, the statement in effect at the time was your "DELETE FROM FRGDDBA.SNAP_ORD_HDR;" but of course it may well be one of many SQL statements and may not be the only problem. Another party could have issued a "LOCK TABLE FRGDDBA.SNAP_ORD_HDR IN EXCLUSIVE...

memonsa, Quick question for you: What is the syntax of your backup command (how do you 'prove' your exit-rtn) ? Reason: One of our UDB V7.1 machines has had a TSM upgrade but (as far as I can see) nothing has changed within the UDB CFG yet the backup is only copying the D/b and NOT the logs...

din987, Whats' wrong with good old: select count(*),year(hiredate) from employee group by year(hiredate)

Presumably you are using UDB 7.2 ? What is the DIAGLEVEL set to ? (it may pay to temporarily bump this up to improve the diagnostics you are getting in db2diag.log). Where is your DIAGPATH pointing to ? 7.2 also introduced the "ARCHIVE LOG" command - does this have the same effect ...

One of the main reasons (for incrementals) is to save time when the db availability is restricted. Another reason is for compatibility with mainframe versions of DB2. I use incrementals to save space i.e. to keep the latest backups on-line but optimising disk-space whilst enabling rapid...

netant, You would not expect any differences between "Incremental" and "Incremental Delta" unless the d/b contents had changed in some way. i.e. If you did a "Full D/B" backup, then an "Incremental D/B" and "Incremental Delta D/B" without...

Peakay, I have never needed this before and it looks as though you are expected to first CONNECT then use the "sqleatin - Attach" to deduce it. An idea - you may already have generated an ?.SPF type file which is a neat text-based breakdown of your db Client Configs. The file can be...

Why not exploit the wonderful db2batch facility. Begin with PERF_DETAIL of 5. You can place all sorts of commands in it for "benchmarking" but it will also yield the source of avoidable overhead. Using the results generated from db2batch, you can then choose the optimum tuning...

I just realised that with UDB 7.2 you now get the "ping" command which tells you the elapsed time in microseconds between the client and (DB) server. This fits your scenario where you are connected to DB "B" but need to check for the availability of DB "A" without...

The quick answer (as mentioned yesterday) is the command db2 list active databases but of course you want the CLI equivalent. I will dig around and come back if I find it. In the mean time, can that db2 command be triggered to generate the list of available databases ?

I take it you are in "SQL SERVER MODE" ? To dump the CLI handle array, CALL QSYS/QSQDMPHA. Then work with the spooled files to examine your output. To dump the CLI handle array for a stream other than the one from which you are issuing the command, CALL QSYS/QSQDMPHA PARM('xxxxxx')...

Renato, See my reply to "netant" a few minutes ago which MAY help because it happened to mention the "WITHOUT ROLLING FORWARD" option. I would need more detail but it may be worth a shot in case it is what you want. If we get no reply, good luck !

Piece of cake. 1 - Use the command: db2 list history backup all for db kdr You can embellish this to (for example) say: db2 list history backup since 20020330 for kdr where you 'derive' 20020330 by various means as 'n' days ago, but lets not get distracted. The command: db2 list...