Problem solve
Get help with specific problems with your technologies, process and projects.
Remote Access to iSeries
Connecting multiple iSeries systems through DDM
Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed data management (DDM). Continue Reading
Tracking remote access users on System i
As remote access through FTP or iSeries Access becomes the standard, the system history log and exit point solutions are two options for tracking users on the AS/400. Continue Reading
Controlling remote access on your IBM i
To control remote access via network connections on the AS/400, the most secure solution is implementation of the exit point controls in the operating system. The server controls serve as gatekeepers to your iSeries, checking IP addresses of remote ... Continue Reading
-
Remove character limits from domain or users on RMTUSER
Use the STRPCCMD command or install advanced rexec daemon to allow more characters for a domain/user on a PC network. Continue Reading
Displaying an image from the AS/400 on a PC, troubleshooting
If an image from the AS/400 does not display on a PC using STRPCCMD, you may need to check to make sure the PC is connected to the iSeries. If it is not, make sure that NetServer is working. If it is, but you can't see the directory QDLS, you need ... Continue Reading
Running a job on the iSeries after it has been transferred to a PC
The REXEC command on a PC or the RMTCMD within iSeries Access allows you to call a program on the iSeries from a Windows PC.Continue Reading
SQL7008 error in iSeries Access and journals
SQL7008 error in iSeries Access is most frequently caused by trying to update a file that is not journaled or when a user lacks authority to the journal.Continue Reading
Telnet connection repeatedly closes
If a Telnet connection to the AS/400 keeps closing, the keep-alive settings may need to be set to lower time limits.Continue Reading
Users unable to sign off of AS/400
When Windows users use option 90 to sign off of AS/400 and they are automatically reconnected, this can be a problem. This can be altered by setting the ENDCNN to *yes.Continue Reading
User authorities for running a remote procedure on the AS/400
Running a procedure on another platorm and transferring a file and running a remote command on the AS/400 requires specific user authorities. These don't need to be Admin settings, but certain authorities must be available to make it work.Continue Reading
-
Users not recognized on iSeries when logged in from Windows 2000
The iSeries Navigator properties control how Windows logs into the Windows server. If the user in Windows is not known to the iSeries (i.e does not exist ) you get an error. Change the properties in iSeries Navigator to use another form of user ...Continue Reading
Remote access from behind a SonicWall firewall
Firewall rules may be preventing remote connections from a PC to AS400. A common problem is iSeries emulation because it requires the signon port to be open (and not just the telnet port).Continue Reading
Setting up personal communications between iSeries and Windows via the internet
To connect iSeries access emulation over the Internet, connect the Internet to your iSeries, and set the AS400 IP adress on the connection setting in Windows.Continue Reading
Using remote AS400 commands in a Windows environment
RUNRMTCMD is the AS400 implementation of REXEC client and it supports 2000 characters, but the REXEC daemon from iSeries Access only supports up to 1000 characters. To run a long command, such as a SQL Server IS package, you will want to use a ...Continue Reading
How to view AFP print spools remotely
In this ATE response, Chip Milosch explains how to user iSeries Navigator to view AFP spool files.Continue Reading
How to make secure iSeries connections
iSeries programming expert Andrew Borts discusses how to make secure connections to your iSeries with the SSL Telnet, VPN Tunnel or even a handheld portable device when on the road.Continue Reading
Take control of your iSeries network security -- Part 2
In his previous tip, Rich Loeber told you how to use the Job Action network attribute to help control network security. This week he shows you how Client Request Access and DDM Request Access control PC access and remote access to your iSeries.Continue Reading
How to use NETSTAT to troubleshoot your iSeries network connections
Do you want to monitor remote users' access to your iSeries? With the Network Status command (NETSTAT) you can check on TCP/IP connections, see how many bytes are going in and out, as well as determine which IP address a device is connected to. In ...Continue Reading
Send "job done" message to a phone
Even today, when most things are automated, there are still times when a series of long batch jobs must be run manually and sequentially. If there is a long job running, with manual steps between jobs, it's nice if the iSeries can "page" you when a...Continue Reading
How to diagnose iSeries Access connection problems -- Part 2
When last we heard from Andrew Borts he was trying to figure out why his iSeries Access connection kept dropping. After many checks, tests and updates, he was still stumped and ended up turning to his network administrators for help. Find out what ...Continue Reading
How to diagnose iSeries Access connection problems -- Part I
What do you do when your laptop won't keep its connection to your iSeries? Andrew Borts walks you through some steps you can take to figure out what the problem is.Continue Reading
Sending files from the iSeries to Windows
Using the parallel port on a remote terminal
Encrypt communication between iSeries and desktops
What do you do when you need to encrypt information flowing between iSeries servers and desktops? Here are a couple ideas.Continue Reading
Set up the iSeries to have 5250 emulation access via the Internet
Connect to a Web site from the iSeries via HTTP
iSeries on the mobile phone
Accessing MS SQL Server database from the iSeries
An ITKE member recently was looking for some information on the best way to execute a SQL statement on the iSeries. Fellow iSeries users offered advice.Continue Reading
Connect the dots: Get your iSeries servers talking to one another
Need to transfer information from one iSeries to another? OS/400 has a tool -- Opti-Connect -- built right in that makes transfers easy and fast.Continue Reading
Sending a PC file to the database file
Automatic file transfer
Running a .BAT file from the IFS
Automatically save, FTP and restore objects to a remote system from a single command
This tool allows you save, FTP and restore up to 10 objects at a time to a remote system using a single command.Continue Reading
Setting iSeries passwords
Using Client Access to do 3270 emulation
Get IFS attributes
Map/mount a Window drive from the iSeries
Creating a Web page to receive cXML code
System timeout issue
Automating the data extracting process
What causes the SQL7008 error?
Connecting to an SQL server
Returning the error code CWBCO1008
Set the port for telnet server via the WRKSRVTBLE command
Determining the attributes of an object
Transferring multiple files on the iSeries
Print copy is being cut off
How to FTP a physical file via iSeries modem
So you want to transfer a file from your iSeries to a remote machine. One way to accomplish that is to FTP the physical file using a Point-to-Point Protocol (PPP) connection.Continue Reading
Telnet sessions that drop off
Removing trailing blanks on text fields
Export an iSeries file
Dealing with an CWBSY1008 error
Uploading a PC ZIP file to the iSeries
Change telnet port number
ODBC alternatives
Alternative to IBM's Client Access
Sending a message to QSYSOPR
What is an PCSWS037 error?
RUNRMTCMD error message
ODBC user connection
Automatically disconnect user sessions
File sharing on the iSeries
Ports for Client Access
The iSeries & AS/400 Programmer's Guide to Cool Things
In this chapter they examine how to make the most of this functionality to help to integrate your 400 with PCs and LANs.Continue Reading
Calling a CL program from a VB program
Adding records to an iSeries file
Slow ODBC connection
Select from logical file
Folder creation on the iSeries
CPYTOPCD command limitation size
Problem accessing QDLS through the iSeries NetServer
SNDDST command to send e-mail to an external address
DB2/400 to SQL server connectivity
A share folder is created when using CPYTOPCD
Java Jar file sitting on the iSeries
What is Brio?
Get users to use a specific IP subnet
Client Access Express & cwbsy1008 problems
ODBC performance issues
Can I key the physical file?
What's causing this program error?
Extract data from the iSeries 400
Error message when Netserver starts
Using iSeries stored procedures with VB
Changing the password expiration notification
DSN files causing ODBC problems
Brio Query to access databases
Export\import data to DB2 on the iSeries
The odbc driver is trying to create a SQL package
QSYSPRT spoolfile with feedback
Prevent users from coming in thru ODBC
Winsock error 10061
Permanently activate data conversion
Our Telnet sessions continue to time out
RUNRMTCMD to execute a command
Where in the AS/400 can I end IP filtering?
Creating an IP print queue
Resolving Client Access CWBSYS1008 error message
Correct method of calling codeedit.exe from the AS/400
Bypassing the login screen on the AS/400