Cannot end RGZPFM on V5R4 (Journaled file)
Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I can delete it and restore it from [...]
Answer Question
| March 8, 2010 8:22 PM
AS/400, AS/400 performance, DB2 Universal Database, ENDJOB, Journaling (Exchange), Recovery, REUSEDLT, RGZPFM, RPG, V5R4
Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I can delete it and restore it from [...]
Answer Question
| March 8, 2010 8:22 PM
AS/400, AS/400 performance, DB2 Universal Database, ENDJOB, Journaling (Exchange), Recovery, REUSEDLT, RGZPFM, RPG, V5R4
Data warehouse vs Database
What is the difference between a database and a data warehouse?
Answer Question
| April 19, 2013 1:40 AM
Data base design, Data warehouse
What is the difference between a database and a data warehouse?
Answer Question
| April 19, 2013 1:40 AM
Data base design, Data warehouse
Logical file
I created a logical file that used a select and values criteria. The file had duplicate records. When I created the same file with a higher security level, the file created without the duplicates. Does anyone know why I would have the duplicate records? The file was deleted ok so it didn’t just append the [...]
Answer Question
| March 7, 2010 2:02 PM
Database issues, iSeries, Logical File
I created a logical file that used a select and values criteria. The file had duplicate records. When I created the same file with a higher security level, the file created without the duplicates. Does anyone know why I would have the duplicate records? The file was deleted ok so it didn’t just append the [...]
Answer Question
| March 7, 2010 2:02 PM
Database issues, iSeries, Logical File
Access help
I have a 10 digit predetermined ID number. What I want to do is when a new number (the number referred to above) is added to the database, information based on this number will appear. The producer is based on the first three digits, the owner is based on the first three and the last [...]
Answer Question
| January 7, 2008 2:21 PM
Microsoft Access
I have a 10 digit predetermined ID number. What I want to do is when a new number (the number referred to above) is added to the database, information based on this number will appear. The producer is based on the first three digits, the owner is based on the first three and the last [...]
Answer Question
| January 7, 2008 2:21 PM
Microsoft Access
export oracle 8i database from unixserver
I have oracle 8i database on unixserver. How i able to export the entire database or schema to windows Xp. plz suggest
Answer Question
| January 7, 2008 9:53 AM
Database, Oracle 8i, Windows XP
I have oracle 8i database on unixserver. How i able to export the entire database or schema to windows Xp. plz suggest
Answer Question
| January 7, 2008 9:53 AM
Database, Oracle 8i, Windows XP
data sync
we have a home grown product developed in cobol and have schema defined as DDS. Our schema is very complex and system has been running for the past 10 years. As part of our application migration, we are planning to create a new database with relatively simple schema. We are planning to move the data [...]
Answer Question
| January 3, 2008 12:12 AM
Database, Synchronization
we have a home grown product developed in cobol and have schema defined as DDS. Our schema is very complex and system has been running for the past 10 years. As part of our application migration, we are planning to create a new database with relatively simple schema. We are planning to move the data [...]
Answer Question
| January 3, 2008 12:12 AM
Database, Synchronization
COBOL data appearing out of order in database
Hi….Would you know what could be the cause of data appearing in an IMS database out of order? Access type is HIDAM, rules=(,H). The segment that is out of sort order is a child, there are 4 occurrences, and it should be sorted by effective date. Here is an example of the database in data [...]
Answer Question
| January 2, 2008 3:06 PM
COBOL, Database
Hi….Would you know what could be the cause of data appearing in an IMS database out of order? Access type is HIDAM, rules=(,H). The segment that is out of sort order is a child, there are 4 occurrences, and it should be sorted by effective date. Here is an example of the database in data [...]
Answer Question
| January 2, 2008 3:06 PM
COBOL, Database
programming for PHP and MySQL
how do i get my login page to direct a user to an appropriate page depending on user username, password and domain previlidges from a database. am using php and mysql
Answer Question
| January 15, 2008 7:58 AM
MySQL, PHP
how do i get my login page to direct a user to an appropriate page depending on user username, password and domain previlidges from a database. am using php and mysql
Answer Question
| January 15, 2008 7:58 AM
MySQL, PHP
How do I connect SAS with Sybase?
Please help me to connect the SAS engine with Sybase data base server. Thanks! Bala
Answer Question
| December 27, 2007 11:54 AM
SAS, Sybase
Please help me to connect the SAS engine with Sybase data base server. Thanks! Bala
Answer Question
| December 27, 2007 11:54 AM
SAS, Sybase
bi-directional data synchronization on System i for db2 databases
I would like to know what would be the best ways to have bi-directional data synchronization on System i between db2 databases . What are the best ways to synchronize data between DDS and SQL-defined files that belong to different applications?
Answer Question
| March 7, 2010 5:46 PM
DataPropagator, DB2 Universal Database, System i
I would like to know what would be the best ways to have bi-directional data synchronization on System i between db2 databases . What are the best ways to synchronize data between DDS and SQL-defined files that belong to different applications?
Answer Question
| March 7, 2010 5:46 PM
DataPropagator, DB2 Universal Database, System i
ECPI / ITT Tech (PLEASE HELP!)
Are these schools good to attend for an AAS in IT/Networking or Web Design? Im at a stand still on the situation. I’ve registered at ECPI but havent fully commited myself yet. I’ve researched both schools and get alot of mixed feelings. I’m looking for a tech job. I have no interest in managment and [...]
Answer Question
| January 31, 2008 5:04 PM
AAS, ECPI, IT careers
Are these schools good to attend for an AAS in IT/Networking or Web Design? Im at a stand still on the situation. I’ve registered at ECPI but havent fully commited myself yet. I’ve researched both schools and get alot of mixed feelings. I’m looking for a tech job. I have no interest in managment and [...]
Answer Question
| January 31, 2008 5:04 PM
AAS, ECPI, IT careers
access supoort beyond 2007
will Microsoft package and support Access beyond office 2007
Answer Question
| December 19, 2007 4:15 PM
Microsoft Access, Microsoft Office
will Microsoft package and support Access beyond office 2007
Answer Question
| December 19, 2007 4:15 PM
Microsoft Access, Microsoft Office
Database
What is the difference between Hsql and Mysql?
Answer Question
| January 3, 2008 6:54 AM
HSQL, MySQL
What is the difference between Hsql and Mysql?
Answer Question
| January 3, 2008 6:54 AM
HSQL, MySQL
SQL query – Unique item with latest date of entry
Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are multiples which show multiple entries for single itemN, for example. item 1 has three date entries [...]
Answer Question
| April 18, 2013 6:44 PM
Aggregate function, Distinct, MAX, Microsoft Access, Query, SQL, Subquery
Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are multiples which show multiple entries for single itemN, for example. item 1 has three date entries [...]
Answer Question
| April 18, 2013 6:44 PM
Aggregate function, Distinct, MAX, Microsoft Access, Query, SQL, Subquery
Bad date.
I’m using the “CPYTOIMPF” to create a .csv file from a iseries database. All fields look good when opening the spreadsheet, except the date. The format of the date is MM/DD/YY 8 position char. field Here’s what it looks like.ñññòð÷
Answer Question
| December 17, 2007 3:20 PM
CPYTOIMPF, CSV, iSeries database
I’m using the “CPYTOIMPF” to create a .csv file from a iseries database. All fields look good when opening the spreadsheet, except the date. The format of the date is MM/DD/YY 8 position char. field Here’s what it looks like.ñññòð÷
Answer Question
| December 17, 2007 3:20 PM
CPYTOIMPF, CSV, iSeries database
Possible Deadlock Condition
I have a server at work that I have been having some serious issues with. It is our main server that holds our database and runs our applications. For the last 3 days we have been receiving ‘Possible Deadlock Condition’ errors which leads to the server locking up. The only way to restart the server [...]
Answer Question
| December 14, 2007 6:04 PM
Database, Possible Deadlock Condition, SQL Server 2005
I have a server at work that I have been having some serious issues with. It is our main server that holds our database and runs our applications. For the last 3 days we have been receiving ‘Possible Deadlock Condition’ errors which leads to the server locking up. The only way to restart the server [...]
Answer Question
| December 14, 2007 6:04 PM
Database, Possible Deadlock Condition, SQL Server 2005
Where is my data
Hi Friends, I am able to enter the data through web form and able to get a query web page with the data being entered, but can’t find the data in the relevant table in Microsoft Access Database. Where is the data hiding and why it is hiding? I am trying to develop a dynamic [...]
Answer Question
| December 10, 2007 12:05 AM
Dreamweaver, IIS, Microsoft Access
Hi Friends, I am able to enter the data through web form and able to get a query web page with the data being entered, but can’t find the data in the relevant table in Microsoft Access Database. Where is the data hiding and why it is hiding? I am trying to develop a dynamic [...]
Answer Question
| December 10, 2007 12:05 AM
Dreamweaver, IIS, Microsoft Access
Is there a way to Call a Lotus Notes agent from Access code and pass Variables?
I’m on a Windows XP Pro System using M.S. Access 2003 and Lotus Notes 6.5. I provide adhoc and ancillary reports to our user community. We now have to send a hotspot to the users to inform them where their Excel files can be found. I created an agent that will send an email to [...]
Answer Question
| January 31, 2008 3:13 PM
Lotus hotspot, Lotus Notes, Microsoft Access, Variables, Windows XP
I’m on a Windows XP Pro System using M.S. Access 2003 and Lotus Notes 6.5. I provide adhoc and ancillary reports to our user community. We now have to send a hotspot to the users to inform them where their Excel files can be found. I created an agent that will send an email to [...]
Answer Question
| January 31, 2008 3:13 PM
Lotus hotspot, Lotus Notes, Microsoft Access, Variables, Windows XP
Delete ODS request via Process Chain
Hello Guru: How can I delete all requests in ODS via Process chain; except last day of the week and last they of the month I do not want to delete. thanks
Answer Question
| December 6, 2007 8:50 PM
DELETE statement, ODS (Operational Data Store), Process chain
Hello Guru: How can I delete all requests in ODS via Process chain; except last day of the week and last they of the month I do not want to delete. thanks
Answer Question
| December 6, 2007 8:50 PM
DELETE statement, ODS (Operational Data Store), Process chain
DB Tracking
I need to track who made changes to a table. can audit do this if so how ?
Answer Question
| July 31, 2008 6:25 AM
Database, DB tracking
I need to track who made changes to a table. can audit do this if so how ?
Answer Question
| July 31, 2008 6:25 AM
Database, DB tracking
