Search results for query: *

Printer set up. Can be printed to via root from command line and also via X-Print. Any non root user can use X-print and it works, however and non root user can't print from command line. We've checked the obvious being permissions, on commands and print queues. Any ideas please? Cheers Greg

Rajakumar, I believe this has been the case on previous installations I've worked on. Am I missing something, hence the question? Greg

Could it be that although you've given ultimte permissions and authorities on the view, your user is only read only on the base table and that's overriding it? Greg

Ties, I use DB2 on AIX and in my testing systems I have many instances, all containing many databases, all on the same server. Just thought it worth pointing out. Cheers Greg

ionobelisk, nice spot. I'll double check everything my IBM consultant tells me from now on. We've had problems with this and what you've said backs up what I've seen as regards 1 and only stored procedure, which we run. Greg

fletchsod, you don't need to make indexes for either the where clause or the order by clause. However 9 times out of 10, indexes which have been defined to support your processing, will greatly enahnce the performance you get from your database. You may wish to consider other performance...

Kozlow, is this your problem? http://www-1.ibm.com/support/docview.wss?uid=swg1JR20798 Cheers Greg

It's as regards the processing it will do on your "field" when it retrieves it. There's an explanation of digits here http://www.idugdb2-l.org/adminscripts/wa.exe?A2=ind0111a&L=db2-l&T=0&F=&S=&P=22044 The substr is saying use from characters 1 to 9. So effectively on retrieval your field...

Similar problem here? http://www.dbtalk.net/ibm-software-db2-udb/sql0443-sql0204-altobj-106492.html Cheers Greg

db2trc ? Cheers Greg

Hi, easy here too. Use an event monitor. http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0005991.htm Cheers Greg

Mag007, 2 databases on the same system, will work equally well. There's a number of options open to you, in terms of setting up replication, you can use the GUI, use SQL (means you need to understand the internal replication asn... tables) or a new scripting language for replication call...

Dan, I have a typo in the above. I should have shown in my second example the word except, rather than intersect. Some examples from the web http://publib.boulder.ibm.com/infocenter/iadthelp/v6r0/index.jsp?topic=/com.ibm.etools.iseries.langref2.doc/rbafzmstmark.htm...

Not had time to look at the post in detail. Just thought it's worth mentioning there is an except operator to find results in one result set, which aren't present in another. Additionally, there is am intersection operator, which finds the elements tha belong to two different result sets...

Martyn, not got db2 in front of me today. Have you tried commands such as db2 list history backup Cheers Greg

I had a similar problem recently only on AIX. The codebase on AIX doesn't yet support LDAP, so we had to back out the LDAP implementation. Cheers Greg

Can you post some diagnostics, such as error message, from db2diag.log or .nfy file. Also the full text of the commands you are issuing and what return you get. Cheers Greg

julen, I thibk you could accomplis this, by describing your data in XML. http://www.tdan.com/i024hy01.htm Greg

julen, I understood CLOBS were for the purpose of storing documents etc. Whether it supports all your requirements, I can;t say, as I've not used them. There's a link here to get you started with further research, should this be a possibility...

Mufasa, to check what you're logging parameters are currently set to 1) connect to the database 2) Issue db2 get db cfg The line you're interested in are as follows Log file size (4KB) (LOGFILSIZ) = 1000 Number of primary log files (LOGPRIMARY) = 3...