comp.sys.ibm.as400.misc - IBM AS/400 miscellaneous topics.
Hi, I am getting error when exporting data from mainframe using db2 connect while i am on db2 on linux. Here is what error looks like ============================================================== $ db2 "export to abc.ixf of ixf lobs to /tmp modified by lobsinfile select * from temp" SQL3104N The Export utility is beginning to export data to file "abc.ixf". SQL3015N An SQL error "-904" occurred during processing. SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: "00C90096", type of resource: "00000F01", and resource name: "0173.0153.AFAAEF7D8CC3D82B26040154CB48.00001". SQLSTATE=57011 SQL3105N The Export utility has finished exporting "10000" rows. ============================================================== I also tried running using UR with select and that does not work either Also, tablespace has been defined as locksize any in OS/390. DB2 should be able to escalate it to tablespace locking. Here is the explanation i found ================================================================ 00C90096 Explanation: The page, row or LOB lock on the page or subpage identified by NAME in message DSNT500I or DSNT501I caused the total number of page, row or LOB locks concurrently held to reach the installation maximum number of page, row or LOB locks (NUMLKUS) allowed for a single agent in the system. This reason code is issued by the following CSECT: DSNILMCL System Action: The operation that encountered this condition is not executed. If a utility job encountered this condition, the utility is stopped. Otherwise, any database updates for the statement that was executing are backed out. Any database reads for the statement that was executing are not executed. The position of the cursor is unpredictable. User Response: Rerun the application after correcting the cause of this resource unavailable condition. ============================================================= Any one had this problem , Please share your experience with me regards, db2admin
Hello All, We have just upgraded to a model 810 from a 720 (both systems on V5R2), and have a problem with authority in the IFS. Users who have mapped PC drives to IFS drivespace are unable to access the drives (incorrect password errors! - not true!), and users who have restricted access to files on the Intranet (using the default AS/400 Web Server - with files in the IFS) are told they are un-authorised to the particular Web page. In all areas where Public access is denied and specific profiles are authorised - only the Public denial is working! Any assistance or information will be greatfully received! Thanks and best regards, Carl
Several Iseries users working on a shared directory on IFS with MS WORD, are generating temporary files when opening a word document on the shared directory, even when the document is propertly colsed the *.TMP file remains in the IFS, and the user cannot delete it via windows explorer but only via operations navigator. The users work with Windows XP SP2 and Word 2000 with all available updates The Iseries runs V5R1M0 with latest PTFs cumulative released the IFS was once converted to type 2 Any clue or any known incompatibility between IFS shared folders and Windows XP SP2? Any PTF available ? Thanks in advance
Hello, I am having here a strange problem. I have installed several PCs with Windows XP Professional. To connect the AS400 IFS (NetServer) I also installed the Windows Client. I can login to the iSeries IFS and browse the directories. I can also copy small Files (600 KB) into the IFS. When trying to copy larger Files ( > 1 MB) I got a message "Cannot copy File xyz: The request is not supproted" When doing the same thing on a Windows 2000 PC with the same user it works. I have searched the IBM Sites but found only a hint regarding a Win XP Session Timeout parameter, but it had not worked. Any hint or idea is appreciated. Matthias