External DB2 Database link/trigger
In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables. Software/Hardware used: i5 i5/os v5m4
In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables. Software/Hardware used: i5 i5/os v5m4
375 pts.
QSECOFR user profile is not allowed in TCP/IP socket mode!
I am getting an error message when I try to connect to the i5 with a Windows based query application. QSECOFR user profile is not allowed in TCP/IP socket mode! I read a couple of articles, it might has something to do with an FTP restriction on i5 side. Could anyone point me to right direction? ...
I am getting an error message when I try to connect to the i5 with a Windows based query application. QSECOFR user profile is not allowed in TCP/IP socket mode! I read a couple of articles, it might has something to do with an FTP restriction on i5 side. Could anyone point me to right direction? ...
i5 software to download currency exchange rates
Does anyone know of i5 software packages or web services that will allow me to download currency exchange rates to our i5 via FTP. I don't need a conversion of dollar amounts, just the rates. Thank You,
Does anyone know of i5 software packages or web services that will allow me to download currency exchange rates to our i5 via FTP. I don't need a conversion of dollar amounts, just the rates. Thank You,
Add Special Authority to User Profiles
I would like to add *JOBCTL, *IOSYSCFG to Basic User Profiles to be able to run Night Jobs. I am only a SECADM that might be the problem. I don't see the option anywhere. Tried CHGUSRPRF, WRKUSRPRF, +. No luck. Please help. I do appreciate any input. Also I need to add components to iSeries...
I would like to add *JOBCTL, *IOSYSCFG to Basic User Profiles to be able to run Night Jobs. I am only a SECADM that might be the problem. I don't see the option anywhere. Tried CHGUSRPRF, WRKUSRPRF, +. No luck. Please help. I do appreciate any input. Also I need to add components to iSeries...
ADD trigger gives a Cross Reference Failed error
I have attempted a very simple CRTPFTRG command to add a trigger to a table specifing * AFTER and *INSERT, however no matter what I do the error code CPD32E7 is stated as the cause of the add trigger failing. Acording to the error message this is because of Operation =1 Reason 6 which refers to a...
I have attempted a very simple CRTPFTRG command to add a trigger to a table specifing * AFTER and *INSERT, however no matter what I do the error code CPD32E7 is stated as the cause of the add trigger failing. Acording to the error message this is because of Operation =1 Reason 6 which refers to a...
Access to 'object in use' attribute of IFS object from QSYS RPGLE
If you open a document which is stored in the IFS with OpenOffice, examining the object with Navigator allows you to see the 'in Use' property - it says that there is 1 Netserver reference. Examining DSPLNK for the same object shows no such 'in use' attribute. How do I get to that attribute in...
If you open a document which is stored in the IFS with OpenOffice, examining the object with Navigator allows you to see the 'in Use' property - it says that there is 1 Netserver reference. Examining DSPLNK for the same object shows no such 'in use' attribute. How do I get to that attribute in...
disable operational assistant access for specific user
I want to diable the operator assistant for a specific users. Currently users access this by pressing the escape key on the keyboard and are therefore able to change their password. How can i therefore prevent this
I want to diable the operator assistant for a specific users. Currently users access this by pressing the escape key on the keyboard and are therefore able to change their password. How can i therefore prevent this
Exchange 2007 install
I'm looking for a HCL for Exchange 2007. We are planning to install Exchange 2007 on a IBM I5/OS, Version 6 Release 1 Mod 0, H Bladecenter. I cannot seem to find an HCL for Exchange 2007, only Server 08. Also we have in place 2 Exchange 03 servers now in the netowrk on same subnet one is on the I5...
I'm looking for a HCL for Exchange 2007. We are planning to install Exchange 2007 on a IBM I5/OS, Version 6 Release 1 Mod 0, H Bladecenter. I cannot seem to find an HCL for Exchange 2007, only Server 08. Also we have in place 2 Exchange 03 servers now in the netowrk on same subnet one is on the I5...
Does anyone know if Version 4.05 of BPCS is compatible with V5R3 of i5/OS?
We upgraded out production machine to V5R3 of i5/OS and we are seeing an issue with BPCS programs not compiling that use to before. This includes errors with /COPY statements that were found but now showing the following errors * QRG2001 Severity: 30 Number: 11 ...
We upgraded out production machine to V5R3 of i5/OS and we are seeing an issue with BPCS programs not compiling that use to before. This includes errors with /COPY statements that were found but now showing the following errors * QRG2001 Severity: 30 Number: 11 ...
PSP Version 5.4 Hiper Group SF99347 and SF99538
I am preparing i5/OS system for a upgrade to Version 6.1 and reviewing the latest V5.4 group hipers and never in the past have applied SF99347 Print and SF99538 Security hipers PTF's. I cannot find any detail information on SF99538 except for " system intergrity problems" and SF99347 " Infoprint...
I am preparing i5/OS system for a upgrade to Version 6.1 and reviewing the latest V5.4 group hipers and never in the past have applied SF99347 Print and SF99538 Security hipers PTF's. I cannot find any detail information on SF99538 except for " system intergrity problems" and SF99347 " Infoprint...
Does anyone know if Mime&Mail (MMAIL) works with i5/os V6R1?
We use MMAIL daily at our shop. We will replace our i5 this winter, the new i5 will come with V6R1. Does anyone know if MMAIL will work on V6R1? Any issues with conversion, APIs or etc.?
We use MMAIL daily at our shop. We will replace our i5 this winter, the new i5 will come with V6R1. Does anyone know if MMAIL will work on V6R1? Any issues with conversion, APIs or etc.?
Port 443 is 'filtered' to internet clients. How can I make it 'open'?
The problem is that HTTPS 443 port isn't accessible from interned, but it is open in local network. Our iSeries is connected to inet via L2TP withot IPSec. If no packet filters are active, nmap shows that ports 25, 80, 110 and even 10322 (WAS admin console) have state 'open' on internet ip...
The problem is that HTTPS 443 port isn't accessible from interned, but it is open in local network. Our iSeries is connected to inet via L2TP withot IPSec. If no packet filters are active, nmap shows that ports 25, 80, 110 and even 10322 (WAS admin console) have state 'open' on internet ip...
ODBC in AS/400, OS/400, System i, i5/OS
Where can I find an ODBC Driver for AS/400? I asked this because I would like to setup an ODBC in AS/400 to connect Lotus Notes (in AS/400) to MySQL (in Windows).
Where can I find an ODBC Driver for AS/400? I asked this because I would like to setup an ODBC in AS/400 to connect Lotus Notes (in AS/400) to MySQL (in Windows).
Logical file update during FTP
When are the associated logical files updated when a physical file is receiving data via FTP?
When are the associated logical files updated when a physical file is receiving data via FTP?
i5 storage extend
Hello, The problem I expose here is about i5 I/O put disk performance. We have an i5 system (520)with disks unite type 4328 that have 140Gb capacity, we want to extend our storage capacity, for that purpose we purchase a drawer with disk type 4327 that have 70Gb.my question is: How would that new...
Hello, The problem I expose here is about i5 I/O put disk performance. We have an i5 system (520)with disks unite type 4328 that have 140Gb capacity, we want to extend our storage capacity, for that purpose we purchase a drawer with disk type 4327 that have 70Gb.my question is: How would that new...
i5/OS change the system name
I need to know which are the elements to take care when somebody want to change the system name, on an i5 box in a network with multi platform... I don't know the others platform (MVS, Unix,...) but I suppose the refer to either the i5 name or IP adress... On the i5 I suppose too it's not a...
View Answer
| Oct 8 2008 0:00 AM GMT
i5/OS, AS/400 system administration, iSeries multi-platform integration
I need to know which are the elements to take care when somebody want to change the system name, on an i5 box in a network with multi platform... I don't know the others platform (MVS, Unix,...) but I suppose the refer to either the i5 name or IP adress... On the i5 I suppose too it's not a...
View Answer
| Oct 8 2008 0:00 AM GMTi5/OS, AS/400 system administration, iSeries multi-platform integration
HTTP Server i5 V5R4
I have the same or similar symptoms as a previous post, but the solution does not solve the problem: We've i5 515 Machine with V5R4M0. After applying the HTTP Latese (cumulative) PTF's, I'm able to have the Main "i5/OS Tasks" page. But when I click on "IBM Web Administration for i5/OS", "Internal...
I have the same or similar symptoms as a previous post, but the solution does not solve the problem: We've i5 515 Machine with V5R4M0. After applying the HTTP Latese (cumulative) PTF's, I'm able to have the Main "i5/OS Tasks" page. But when I click on "IBM Web Administration for i5/OS", "Internal...
i5/OS vs MS sequel server 2005
The powers that be would like to replace our 20 year old i5 home grown billing system with a .NET solution (partial) over MS SQL Server 2005. How do we convince the powers that be to keep & improve what they have or should we just surrender and start taking .NET classes?
The powers that be would like to replace our 20 year old i5 home grown billing system with a .NET solution (partial) over MS SQL Server 2005. How do we convince the powers that be to keep & improve what they have or should we just surrender and start taking .NET classes?
Kronos
I have Kronos application installed on a production 525 its been requested that I implement the same environment on a training 525. Do I just lay the current libraries on the box or do I have to perform the install from scratch?
I have Kronos application installed on a production 525 its been requested that I implement the same environment on a training 525. Do I just lay the current libraries on the box or do I have to perform the install from scratch?
